I'm running MS-Office 2003 Professional w/SP2. I have found an odd behavior
with 2 different Excel worksheets that I wanted to confirm if this is
standard for Excel. One of the files has many formulas and is set to
automatic calculation within Tools, Options. I have another file that also
has many formulas, but it's set to manual (recaculation before save). If I
open the automatic file, make changes, save and close the file and then open
the manual file, the settings for this second file are changed to automatic
from manual. If I fully close Excel before switching between the two
different files, the settings are kept correctly.

Is this normal behavior for Excel 2003? If so, how can I get the settings
to stay with each file?

Thanks.

Ken