How do I keep Excel in manual calcuation?

[iumike2004]

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.

[Peter Ellis]

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

"iumike2004" wrote:

> 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.

[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

"iumike2004" <iumike2004@discussions.microsoft.com> wrote in message
news:34D68831-11FD-4B48-9F25-72313BC7430E@microsoft.com...
> 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.