If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|