Hi Yb,

It seems to work. Even if the manual calculation options was'nt checked in
the hidden files at startup, I saved them again. and excel is back on
automatic calculation !


Calculation mode is saved with a file, but Excel sets the mode based on the
FIRST file it opens.

If you have two files open and change calc mode to manual and after that
save both files, both will be saved with calc to manual.

So if you start Excel and start off with opening a file that had calc set to
Auto at its saving, subsequent opening of a file with calc set to manual
will not change the calc mode, it will stay Auto.

Saving of that last file at this time will however set that file back to
auto calc (because that is what is currently set), so next time you *start*
by opening that file, it will not be in Manual calc mode anymore.

Confusing, eh?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com