Home

WorkBook Calculation automatic mode

kbnreddy2002
Occasional Visitor

unable to set the workbook calculation to automatic mode, every time I open xls it's set Manual mode

2 Replies
Once you change the setting in Preferences remember to quit Excel totally, not just close the spreadsheet. When you restart it should accept you new settings.

Also note that if you open any workbook that was saved as Manual Mode, it will cause Excel to switch all workbooks open to manual, It cannot have some automatic and some manual, so the manual mode will essentially infect the other workbooks with the same setting. So make sure you switch to automatic mode, then save EVERY open workbook, close Excel, then reopen the workbook in question. It should be in automatic mode at that point.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies