EXCEL Formulas

[João Sousa]

Good Afternoon,

I have a Office 2002 with SP3. I open a old file with formulas, and select
the option "Automatically Calculate" and save the document.
When I go open it again, the document have the option "Manually" active and
no the option that I have save the document ("automatically Calculate").
This happen every time I open a old file... if I open a new file and save
with "automatically calculate" and save... when I Open the option is correct.


Can anyone help me??

Thanks

 

[Brent]

You should be able to go into the template for excel and set that default to
automatic. Otherwise, every "new" file you have not saved as automatically
calculating, will be set to manual calculation.

Brent

 

[Gary''s Student]

The option is getting over-written.

First open a new file and verify that you are in automatic mode. Leave the
new file open and the old files and save them.

The problem you are seeing is that if you open several files, Excel
establishes its options to the set in the first file you open!!

 

[João Sousa]

Good Afternoon,

I don't understand doing what you say, how I gonna solve this problem.