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?

Sounds like you have a macro in there. If you go to Tools - Macros - Visual
Basic Editor, look to the top left. If you see a folder named Modules, you
have a macro in there. You can right-click on the module within this folder
and click remove module....

"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?

I wouldn't recommend removing a module without knowing what was in it.

And I'm not sure how a macro would affect calculation, either.

Sean Timmons wrote:

Sounds like you have a macro in there. If you go to Tools - Macros - Visual
Basic Editor, look to the top left. If you see a folder named Modules, you
have a macro in there. You can right-click on the module within this folder
and click remove module....

"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

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