Calculation Settings

[David Lipetz]

In Excel 2003 SP3, I though setting Calculation to Manual
(Tools/Options/Calculation/Manual) was an application setting rather than a
workbook setting.

However, I saved a workbook while Calc was set to Manual and distributed it
to a colleague for use. When it was openend, he reported that none of the
cells were populating correctly as they had been before. I called him and
discovered that calculation was set to Manual and that he did not make that
setting change.

After futzing around, it does appear that the setting is stored in the
workbook so opening a workbook can change the application setting. Is this
the correct behavior? I would prefer that Options be managed by the
application and not the workbook.

David

 

[Don]

Calc is managed by by the workbook and cannot be fixed by the program. if
you search this group for "personal.xls", you will see that you can use a
macro to force excel to set the calc to auto (# of iterations too). That
way, all new excel files that you create from scratch will have auto calc set.

 

[Dave Peterson]

Calculation is an application setting, but it's a strange one.

Excel picks up this setting from the first workbook it opens in the session. So
if your coworker was unlucky enough to open your workbook as the first workbook
in that session, then the application setting got changed to manual.

Lots of people have the same preference as you -- but it doesn't work that way
<vbg>.

 

[David Lipetz]

Thank you. I will investigate.

Calc is managed by by the workbook and cannot be fixed by the program. if
you search this group for "personal.xls", you will see that you can use a
macro to force excel to set the calc to auto (# of iterations too). That
way, all new excel files that you create from scratch will have auto calc
set.