I've never seen this, but there have been posts where calculation seems to be
broken (but double check that calculation mode first!).

I'd select all the sheets (right click on any tab and choose Select All Sheets)
Then select all the cells (ctrl-a a few times)

Then Edit|Replace
what: = (equal sign)
with: = (same equal sign)
replace all

And ungroup the sheets (rightclick on any of the sheets and choose Ungroup
Sheets).

That's important!!! Make sure you do this. Otherwise, almost any change you
make to any in that group of sheets will be made to all those in the group.

Then test your changes again to see if calculation woke up.

ab wrote:

I have a workbook here with multiple tabs. If I update one tab by changing
the number in it, it does not calculate automatically without hitting the F2.
The calculation function is set to automatic. Whats going on?

--

Dave Peterson