Automatic/Manual calculation question

[Al Jones]

We use Excel 2000. One of the employees here has
discovered that when she opens a spreadsheet set to manual
calculation (Tools/Options/Calculation Tab)then opens one
or more additional spreadsheets that are set to automatic
calculation (without closing the original), all
spreadsheets take on the manual calculation setting.
The reverse is also true. Opening a spreadsheet set to
automatic calculation and then opening one that was setup
to manually calculate results in the second spreadsheet
taking on the automatic calc. characteristic
(temporarily). I've observed the same on a test PC with
Excel2000 and SP-3.
Is there a patch or a way to have two or more spreadsheets
open in Excel 2000 at the same time but without each
taking on the calculation setting of the first spreadsheet?

 

[Charles Williams]

Hi Al,

The Calculation mode setting is an Application level setting stored in each
saved workbook.
(Yes this is confusing).

So Excel only has a single setting for all the workbooks that are open, and,
yes you are absolutely correct, Excel takes the initial setting from the
first workbook opened.

I do not know of a simple way of getting round this.


regards
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com