If you are sure calc mode is automatic perhaps somehow you have changed the
formulas to text mode.

Select all sheets then select all cells on active sheet.

EditReplace

What: =

With: =

Replace all.

Ungroup the sheets and try again with entering a figure.


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 10:26:02 -0800, Jamal
wrote:

I have a large workbook (size about 10 MB) consisting of about 40 sheets
summarised into about five sheets. When I change a figure in one sheet it
used to update the summaries. It has stopped doing that. The option is set to
auto claculation.

To update now I have to go into the formula cell by pressing F2 and press
return. Pressing F9 does not work.

What has gone wrong here and how can I resolve this? Your help most
appreciated. Thanks.