Just a suggestion and it may not work...

Select all the cells
Edit|replace
what: = (equal sign)
with: = (same equal sign)
replace all

Excel will see that your formulas need to be reevaluated. And maybe it'll wake
up excel!

revdeacon wrote:

I have a large spreadsheet (12 MB)
Having trouble with a tab: the cell on one tab is equal to the sum of three
cells on another tab. The only way the cell will calculate is if I select it,
and then hit F2 and enter.

It will not recalculate using F9 (If I have the manual recalc on)
And will not automatically recalc if the Manual recalc is off.

Any suggestions?

--

Dave Peterson