software

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.

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

quot;iumike2004quot; wrote:

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

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
www.decisionmodels.com/calcsecretse.htm

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

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