'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Switching to Manual Calculation With Multiple Sheets
Question details
Selecting multiple worksheets changes the calculation mode from Automatic to Manual, causing formulas to stop updating.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Grouping or selecting multiple worksheets simultaneously to edit or view data.
- Observed behavior
- The application's calculation setting switches to Manual, and formulas stop recalculating until only a single worksheet remains selected.
Check your Excel version by navigating to File > Account to verify if you are running version 2405 or 2407, which are known to contain this specific calculation bug.
Force Formula Recalculation Manually (Workaround)
Use this method to manually update your formulas while multiple worksheets are still selected without changing your sheet grouping.
Since this behavior is a recognized bug in specific Excel updates, the application temporarily suppresses automatic calculations. You can bypass this limitation by manually forcing the spreadsheet to recalculate your formulas while the multiple sheets remain active.
Navigate to the 'Formulas' tab on the Excel Ribbon and click the 'Calculate Now' button to update all active formulas.
Alternatively, simply press the 'F9' key on your keyboard to instantly force a calculation across the selected sheets.
Restore Automatic Calculation by Selecting a Single Sheet
This solution returns Excel's calculation mode to its default automatic state by ungrouping your worksheets.
Try WPS Office for Bug-Free Spreadsheet Calculations
If you are frustrated by Microsoft Excel calculation bugs and update issues, switch to WPS Office. It provides a stable, lightweight, and completely free alternative for handling complex spreadsheets and automatic formulas across grouped sheets.
- 1. Download and install WPS Office: Visit the official WPS website to download the free suite and follow the straightforward installation prompts.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your existing Excel (.xlsx) files directly with zero compatibility issues.
- 3. Work across multiple sheets smoothly: Select multiple worksheets and edit your data while enjoying continuous, bug-free automatic formula recalculation.
Frequently Asked Questions
Why do my formulas stop updating when I select multiple tabs in Excel?
In Excel versions 2405 and 2407, selecting multiple worksheets triggers a known bug that changes the application's calculation setting from Automatic to Manual, which prevents your formulas from updating in real-time.
How can I check which calculation mode Excel is currently using?
Go to the 'Formulas' tab on the Ribbon and click on 'Calculation Options'. A checkmark will appear next to the currently active mode, showing whether it is set to Automatic or Manual.
Is there a permanent fix for the multiple sheets calculation bug?
Currently, this is an acknowledged product bug in specific Excel versions. Until an official patch is released by Microsoft, you must use the F9 key to manually recalculate or select a single sheet to restore automatic calculation.
