Excel caluclation setting reverts back to manual when I close Exce


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
 
Ad

Advertisements

G

Guest

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
 
G

Guest

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
 
G

Guest

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top