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.