Good idea to save the file with calc mode set to automatic

BUT.......a warning.

If a workbook with calc mode set to manual is the first opened workbook in a
session, all subsequent workbooks opened will also be set to manual even if
they were saved in automatic mode.

You must be aware of this feature in all versions of Excel.


Gord Dibben MS Excel MVP

On Wed, 7 Jan 2009 10:13:00 -0800, Michael
wrote:

From the Main Menu Bar select:
Tools- Options
From the Calculation Tab Click on Automatic, then save your file.