ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto Calculate Keeps Resetting to Manual (https://www.excelbanter.com/excel-worksheet-functions/261473-auto-calculate-keeps-resetting-manual.html)

Shirley

Auto Calculate Keeps Resetting to Manual
 
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.



Fred Smith[_4_]

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.




Bernard Liengme[_2_]

Auto Calculate Keeps Resetting to Manual
 
As a follow on to Fred's answer - do you have workbooks in the XLSTART
folder?
These will open every time you start Excel and could be hidden
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


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




All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com