Stop Calculation mode being changed by other workbooks
Its very confusing when you think a workbook is being calculated automatically but suddenly it has switched to manual. This is caused by Excel deciding its calculation mode(Manual or Automatic) from the first workbook opened in any Excel session and ignoring the calculation mode that was saved with the next workbooks opened.
(I suspect that fixing this problem requires Workbook Level Calculation)
Charles Williams commented
All of these suggestions point at the same problem: the current way Excel handles calculation mode is very confusing and restricted. but MS cannot change the existing method without breaking millions of Excel-based applications and workbooks.
so the only solution I can see is to add one or more new calculation options that allow you to override the current settings whilst the new options are in effect.
My suggestions for these are:
1. Calculate Active Workbook only using its own workbook calc mode
2. Set Initial Calculation Mode (First workbook - which is the current method, Auto, Manual, Auto except Tables)
Kenneth: I don't see how they are contradictory. The excel calculation mode is based on the first workbook opened, which results in a random behavior (basically in which calculation mode was the excel session of the person who last saved the workbook you are opening).
And when that setting is changed, it changes for the whole excel session.
Kenneth Barber commented
And both people are Charles... interesting. One of these 2 requests must be based on either false information or different versions of Excel. Which one is it?
Note for XL team: this is the opposite request of: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13541442-calculation-mode-should-not-be-tied-to-the-spreads