| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why did auto calculate suddenly change to manual calcu... | Excel Discussion (Misc queries) | |||
| Shared Workbook-Formulas constantly resetting to manual | Excel Discussion (Misc queries) | |||
| manual calculate | Excel Discussion (Misc queries) | |||
| My IF statement is stating False but if I manual calculate it it | Excel Discussion (Misc queries) | |||
| why would calculate change from automatic to manual on its own? | Excel Discussion (Misc queries) | |||
Hybrid Mode
