formulas updating

[Laurie]

I have a spreadsheet with an addition formula toward the end of the rows.
There is one cell in the row, before the cell with the totals formula, that
is not included in the formula. Suddenly, the sheet is updating the formula
to include this cell. I don't want this. What's the setting to make Excel
stop acting on it's own here? This only happens on one machine, running
Excel 2003.

Thanks.

 

[Niek Otten]

Check the setting here:

Tools>Options>Edit tab, Extend data range formats and formulas

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet with an addition formula toward the end of the rows.
| There is one cell in the row, before the cell with the totals formula, that
| is not included in the formula. Suddenly, the sheet is updating the formula
| to include this cell. I don't want this. What's the setting to make Excel
| stop acting on it's own here? This only happens on one machine, running
| Excel 2003.
|
| Thanks.

 

[Laurie]

Thanks - that did the trick....