Calculation Issues

Fix Excel Not Recalculating When Multiple Worksheets Are Selected

Bushra Parveen Sep 25, 2026 869 views

Question details

Users experience an issue where formulas stop updating automatically after selecting multiple worksheets and copying or inserting cells.

How to Fix Excel Not Recalculating When Multiple Worksheets Are Selected

Product: Microsoft Excel
Device & OS: not provided
Scenario: Copying or inserting cells while multiple worksheets are grouped together.
Observed behavior: Excel unexpectedly switches to Manual calculation mode, requiring the user to manually trigger recalculation to update formula results.

Before you start

Ensure you have saved your current workbook to prevent data loss before modifying calculation settings, and verify if the calculation issue happens in all files or just one specific document.

Solution 1Recommended

Restore Automatic Calculation Mode

Manually switch the calculation options back to Automatic after the workbook unexpected changes to Manual mode.

In newer versions of Excel, performing actions like copying or inserting cells across multiple grouped worksheets can inadvertently trigger a behavior that changes the calculation mode to Manual. Resetting this option will immediately restore expected functionality.

Ungroup Worksheets

Right-click on any worksheet tab at the bottom of the Excel window and select 'Ungroup Sheets' to ensure you are only modifying the active sheet.

Navigate to Formulas Tab

Click on the 'Formulas' tab located in the top ribbon menu.

Change Calculation Options

Locate the 'Calculation' group, click on 'Calculation Options', and select 'Automatic' from the drop-down menu.

Force Immediate Recalculation

Click the 'Calculate Now' button in the ribbon or press the F9 key on your keyboard to instantly update all formulas.

Report to Microsoft: If this calculation bug happens frequently in your workflow, it is recommended to report the behavior to Microsoft Support, as it is tied to specific updates in newer Excel versions.

Solution 2

Use Keyboard Shortcuts for Quick Recalculation

If your workflow strictly requires working with grouped sheets and calculation keeps pausing, use shortcuts to force recalculations on the fly.

Free Microsoft Office alternative

Experience Flawless Multi-Sheet Calculations with WPS Office

Tired of Excel bugs interrupting your workflow? WPS Office offers a free, lightweight, and highly compatible alternative that handles multi-sheet operations and complex formulas seamlessly, without unexpectedly disabling automatic calculations.

1. Download and Install: Get WPS Office for free from the official website and easily install it on your device.
2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx workbook directly without conversion.
3. Group Sheets with Confidence: Select multiple worksheets and copy or insert cells; WPS Spreadsheet will reliably maintain your automatic calculation settings.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Reliable automatic formula calculation, even when grouping multiple worksheets.Lightweight design that runs smoothly on both older and newer devices.Familiar user interface for a zero-learning-curve transition.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change my calculation to manual automatically?

In some versions of Excel, grouping multiple worksheets and performing certain actions (like inserting or copying cells) triggers a known bug or safety mechanism that switches the calculation mode to Manual to prevent performance freezes.

How do I group or ungroup multiple worksheets in Excel?

To group worksheets, hold down the 'Ctrl' key and click the sheet tabs you want to select. To ungroup them, simply right-click any selected sheet tab and choose 'Ungroup Sheets' from the context menu.

Can I permanently lock the calculation setting to Automatic?

Calculation settings are generally saved with the workbook and determined by the first workbook you open in an Excel session. While you cannot permanently lock it application-wide, ensuring your base templates are saved in Automatic mode helps prevent it from defaulting to Manual upon startup.

Excel & Data Problems