Calculation Issues

How to Fix Excel Automatic Calculation Switching to Manual

Maira Mehtab Sep 20, 2026 868 views

Question details

The user needs to fix an issue where Excel unexpectedly changes its calculation setting from automatic to manual.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working on data and formulas across multiple selected or grouped worksheets within a single workbook.
Observed behavior: The calculation option automatically switches to manual when worksheets are grouped, preventing formulas from updating.

Before you start

Verify if your formulas are calculating normally on a single active worksheet before modifying workbook settings.

Solution 1Recommended

Ungroup Multiple Worksheets

Excel may change calculation behavior to manual when multiple sheets are grouped. Ungrouping them usually restores normal automatic calculation.

When you select multiple sheets in Excel, the software groups them to allow bulk editing. However, this grouped state can sometimes force the calculation options to switch to manual to preserve system performance.

Identify grouped sheets

Look at the sheet tabs at the bottom of your Excel window. If multiple tabs are highlighted or underlined, they are grouped.

Open the context menu

Right-click on any of the currently selected worksheet tabs.

Ungroup the sheets

Click 'Ungroup Sheets' from the pop-up menu. Alternatively, simply click on the tab of an unselected sheet to break the group.

Run the calculation

Verify if your formulas are now updating automatically. You may need to press F9 to trigger the first automatic recalculation.

Quick Tip: You can always tell if sheets are grouped by looking at the very top of the Excel window; the word '[Group]' will appear next to your workbook name.

Solution 2

Manually Reset Calculation Options

If ungrouping the sheets does not automatically revert the setting, you must manually reset the calculation mode.

WPS Spreadsheet Solution

Easily Manage Workbook Calculations with WPS Office

WPS Spreadsheet provides a stable and intuitive environment for handling complex data across multiple worksheets. You can seamlessly ungroup sheets and manage your calculation preferences without unexpected interruptions.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx file.
2. Ungroup sheets: Right-click the highlighted sheet tabs at the bottom and click 'Ungroup Sheets'.
3. Navigate to Formulas: Click the 'Formulas' tab on the top menu ribbon.
4. Enable automatic calculation: Click the 'Calculation Options' drop-down and select 'Automatic' to restore dynamic formula updates.

Intuitive sheet management and formula calculation settings.100% compatibility with Microsoft Excel formats (.xlsx, .xls).Free, lightweight, and fast processing for large datasets.Familiar interface ensuring a zero-learning-curve transition.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel calculation keep switching to manual?

Excel often switches to manual calculation when multiple worksheets are grouped to prevent software lag during bulk data entry. Additionally, if the first workbook you open in an Excel session was saved in manual mode, all subsequently opened workbooks will inherit that setting.

How do I force Excel to recalculate my formulas?

You can manually force Excel to recalculate your entire workbook by pressing the F9 key. If you only want to recalculate the active worksheet, press Shift + F9.

How do I stop Excel from grouping sheets automatically?

Excel does not group sheets automatically unless commanded. Ensure you are not accidentally holding down the 'Ctrl' or 'Shift' keys while clicking sheet tabs, as this is the standard shortcut for selecting multiple sheets.

Excel & Data Problems