Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas updating
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas updating
Check the setting he
ToolsOptionsEdit tab, Extend data range formats and formulas -- Kind regards, Niek Otten Microsoft MVP - Excel "Laurie" wrote in message ... |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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas updating
Thanks - that did the trick....
"Niek Otten" wrote: Check the setting he ToolsOptionsEdit tab, Extend data range formats and formulas -- Kind regards, Niek Otten Microsoft MVP - Excel "Laurie" wrote in message ... |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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum formulas not updating | Excel Worksheet Functions | |||
updating formulas | Excel Discussion (Misc queries) | |||
formulas not updating | Excel Discussion (Misc queries) | |||
Formulas not updating | Excel Discussion (Misc queries) | |||
Formulas Not Updating!!! | Excel Discussion (Misc queries) |