View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Auto Calculate Keeps Resetting to Manual

The recalculation setting comes from the first workbook you open. Do you
have another workbook that has its setting to manual?

Regards,
Fred

"Shirley" wrote in message
...
Cannot get this to stay at automatic. Any thoughts why?

New workbook, nothing complicated (b2/b3). I save the document, reopen
and
set to recalculate. The next day when I open, it's back to manual.

I hate when things weird out.