Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole workbook recalculates when I change a cell
I'm working in Excel 2003 and have a large workbook with many formulae. I
thought M/soft had designed Excel to only recalculate formulae directly affected by a change and yet, when I make a change to a cell that has no dependents, I still have to wait while the whole book recalculates. I know I can switch to manual calculation and use F9 but would prefer not to. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole workbook recalculates when I change a cell
Why don't you set the calculation to manual, but make sure that the
RECALCULATE BEFORE SAVE is checked. Other than that I don't know of any other way to control the recalc method in Excel -- Kevin Backmann "Smallweed" wrote: I'm working in Excel 2003 and have a large workbook with many formulae. I thought M/soft had designed Excel to only recalculate formulae directly affected by a change and yet, when I make a change to a cell that has no dependents, I still have to wait while the whole book recalculates. I know I can switch to manual calculation and use F9 but would prefer not to. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole workbook recalculates when I change a cell
You may have some volatile functions in the workbook like INDIRECT or
even NOW, and there may be other cells which are dependent on these and therefore the sheet is recalculated more often than you would like. Pete On Oct 10, 1:51 pm, Smallweed wrote: I'm working in Excel 2003 and have a large workbook with many formulae. I thought M/soft had designed Excel to only recalculate formulae directly affected by a change and yet, when I make a change to a cell that has no dependents, I still have to wait while the whole book recalculates. I know I can switch to manual calculation and use F9 but would prefer not to. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
whole workbook recalculates when I change a cell
Thanks Kevin - that looks like the only solution. Just found this on the web:
"Microsoft Excel calculates during different events like column auto-resizing, when entering anything in any cell, and so forth. However, Excel can only track 65,536 dependencies to unique references for automatic calculation. After the workbook has passed this limit, Excel no longer attempts to recalculate only changed cells. Instead, it recalculates all cells after each change. This behavior is by design of Microsoft Excel. However, the "Calculate" message in the status bar indicates that Microsoft Excel can no longer track the formula dependencies and is calculating every formula in the workbook after each change." "Kevin B" wrote: Why don't you set the calculation to manual, but make sure that the RECALCULATE BEFORE SAVE is checked. Other than that I don't know of any other way to control the recalc method in Excel -- Kevin Backmann "Smallweed" wrote: I'm working in Excel 2003 and have a large workbook with many formulae. I thought M/soft had designed Excel to only recalculate formulae directly affected by a change and yet, when I make a change to a cell that has no dependents, I still have to wait while the whole book recalculates. I know I can switch to manual calculation and use F9 but would prefer not to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pulling color from cell of workbook to another linked workbook | Excel Discussion (Misc queries) | |||
Excel recalculates on startup? | Excel Worksheet Functions | |||
my colors change in my workbook when I open another workbook | Excel Discussion (Misc queries) | |||
change a function in a workbook without changing every cell | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |