Which will change back to manual next time you open it if you first open a
workbook that has calc mode set to manual.

Excel uses the calc mode of the first workbook opened during a session.

Always be aware of that "feature".


Gord Dibben MS Excel MVP

On Sun, 14 Sep 2008 16:24:52 -0700 (PDT), Pete_UK
wrote:

To set it back to Automatic, click on Tools | Options | Calculation
tab then check Automatic - then save the file.