Excel caluclation setting reverts back to manual when I close Exce

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm running Office 2003 SP1 on XP SP2. I have an Excel SS that will not
retain the caluclation setting so that I have to change it to Automatic each
time I open the SS.

This is not a large file and has only a few functions.

Anyone have a suggestion as to how I can get Automatic to stay turned on?

thanks, in advance.
mm
 
These are suggestions:
1. make sure no worksheet or workbook templates (.XLT) are forcing back to
manual

2. make sure no start-up macros are forcing back to manual calculation
 
Gary's:
Wouldn't the template only effect the original build of the SS? I didn't
think the template would be involved on a re-open for modification. I could
easily be wrong though.

No macros in this SS.

thanks,
mm
 
Gary's,

Your macro suggestion made me go back and find that i was calling macros
after all. thanks for making me double-check.
I'm fixed up now.

thanks,
mm
 
Back
Top