Excel always starts in Manual Calculation mode

[cjskinner]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

Every time I open an Excel workbook, the Calculation mode is set to Manual, even if that workbook was saved in Automatic mode. Is there a way to force Automatic mode to be the default, since that is the mode I prefer 99% of the time?

Thanks,
Cory

 

[CyberTaz]

Hi Cory -

Automatic is the default, so if that setting doesn't "take" there must be a
problem somewhere - but not necessarily a major one.

First, change the setting in an existing file then make some other change in
the workbook itself. [Changes to Preferences don't always get saved if no
other changes cause the file to be updated.] Close & save, then see what
happens when you reopen it.

Also, check the default setting when you create a new blank workbook.

Do you have a workbook template that you base new files on?

Post the reply to each of those points & we'll go from there.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[cjskinner]

Aha! Your last question made me think of something.

I do have a "PERSONAL.xls" that opens automatically every time I open Excel. It opens in the background and is hidden, so I don't usually give it much thought. I unhid it, and changed its preferences to Automatic calculation, saved it and closed Excel, etc.

Now when I open Excel, it opens in Automatic mode, as expected.

Thanks for your prompt assistance, Bob!

Cory

Hi Cory -

Automatic is the default, so if that setting doesn't "take" there must be a
problem somewhere - but not necessarily a major one.

First, change the setting in an existing file then make some other change in
the workbook itself. [Changes to Preferences don't always get saved if no
other changes cause the file to be updated.] Close & save, then see what
happens when you reopen it.

Also, check the default setting when you create a new blank workbook.

Do you have a workbook template that you base new files on?

Post the reply to each of those points & we'll go from there.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

Every time I open an Excel workbook, the Calculation mode is set to Manual,
even if that workbook was saved in Automatic mode. Is there a way to force
Automatic mode to be the default, since that is the mode I prefer 99% of the
time?

Thanks,
Cory

 

[CyberTaz]

That'll do it Glad it was something that simple. Thanks for posting back
with your results!

Regards |:>)
Bob Jones
[MVP] Office:Mac

Aha! Your last question made me think of something.

I do have a "PERSONAL.xls" that opens automatically every time I open Excel.
It opens in the background and is hidden, so I don't usually give it much
thought. I unhid it, and changed its preferences to Automatic calculation,
saved it and closed Excel, etc.

Now when I open Excel, it opens in Automatic mode, as expected.

Thanks for your prompt assistance, Bob!

Cory

Hi Cory -

Automatic is the default, so if that setting doesn't "take" there must be a
problem somewhere - but not necessarily a major one.

First, change the setting in an existing file then make some other change in
the workbook itself. [Changes to Preferences don't always get saved if no
other changes cause the file to be updated.] Close & save, then see what
happens when you reopen it.

Also, check the default setting when you create a new blank workbook.

Do you have a workbook template that you base new files on?

Post the reply to each of those points & we'll go from there.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

Every time I open an Excel workbook, the Calculation mode is set to Manual,
even if that workbook was saved in Automatic mode. Is there a way to force
Automatic mode to be the default, since that is the mode I prefer 99% of the
time?

Thanks,
Cory