Calculation mode should not be tied to the spreadsheet
The way the calculation mode in Excel is set up defies any form of common sense.
People use manual vs automatic calculations as a way to work, not a spreadsheet specific thing. I always want my calculations to be manual, though when I open a new session, the mode in which Excel starts is a complete lottery and I have to change the setting all the time.
The calculation mode setting should be user specific, not workbook specific.
Jon Wittwer commented
I prefer the Automatic/Manual calculation option to be specific to the workbook, regardless of what other workbooks have been opened. People using my spreadsheets often email me to say their spreadsheet has stopped working, and the majority of the time it is because Excel has switched the calculation option to Manual.
Note for XL team: this is the opposite request of https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/15369393-stop-calculation-mode-being-changed-by-other-workb
Gareth Hayter commented
That's the reason that I added the calculation mode alert to the FormulaDesk add-in, because if it's set to manual you might not even realize it, and bad things start to happen.
That's what it should be intuitively but that's not the case. Try setting your calculations to manual and opening a new excel session.
Kenneth Barber commented
I thought it was application-specific. That is, the calculation mode is whatever you left it at last, regardless of the workbook.