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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies