Make sure your personal.xls or any other workbook which opens when Excel
opens has its setting to Automatic. The setting is determined by the first
workbook opened, hidden or not.

"Dan." wrote in message
...
Hi,

I'm using Excel 2002 SP3 and the calulation option is set as Manual. When
I
go and change it to Automatic (which is the way I want it) it works fine
until I close and reopen Excel where upon it sets itself back to Manual.
How can I set it to save to Automatic?

I have, by the way, removed and reinstalled Office, but still the same
issue.

Thanks for your time.