View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Calculation changing from Automatic to Manual

"Erin" wrote:
The calculation option in Excel 2003 keeps switching to Manual.


Do you have any macros that might be executed at open time -- either an
event or volatile macro or due to a volatile formula?

I wonder if a macro is setting manual calculation, then failing to set
automatic calculation for any of a number of reasons.


----- original message -----

"Erin" wrote in message
...
The calculation option in Excel 2003 keeps switching to Manual. I choose
Automatic and when I reopen Excel, it's back to Manual again. Haven't had
this problem before -- how to do I make it stay at Automatic?