How do I keep Excel in manual calcuation?

[Guest]

How do I keep Excel in manual calculation? I switch it to manual using the
tools-options menu, but it keeps switching back to auto.

 

[Guest]

Could a macro that starts up with Excel or the workbook be resetting the
option?

 

[Charles Williams]

Excel's calculation mode is at Application level rather than workbook level,
and is set from the first non-empty, non-XLA workbook opened, which could
for instance be Personal.xls.

for more details see
http://www.decisionmodels.com/calcsecretse.htm

regards
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com