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.