Calculation Issues

Fix an Excel Column Total That Does Not Recalculate Automatically

Rana GarciaRana Garcia Nov 14, 2026 868 views

Question details

The user needs an Excel column total to update automatically when a number in the column changes.

Fix an Excel Column Total That Does Not Recalculate Automatically
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user changes a number in a column that is included in a total formula.
Observed behavior
The column total does not update after the number is changed.
Before you start

Open the workbook in Excel and identify the cell containing the column total. Check that the changed number is included in the total formula's range.

Solution 1Recommended

Recalculate the Worksheet and Enable Automatic Calculation in Excel

Use this method to check whether Manual calculation is preventing the total from updating.

1
Recalculate the worksheet

Select the worksheet containing the total and press Shift+F9 to recalculate it. Check whether the total updates.

2
Open calculation settings

In Excel, select File > Options > Formulas.

3
Enable automatic calculation

Under Calculation options, set Workbook Calculation to Automatic, then select OK.

4
Test the total

Change a number included in the total formula and confirm that the total updates automatically.

Recalculate the Worksheet and Enable Automatic Calculation in Excel
Worksheet versus workbook recalculation: Shift+F9 recalculates the active worksheet. Press F9 to recalculate formulas in all open workbooks.
Free Microsoft Office alternative

Work With Column Totals in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with formulas while moving between office suites.

Create and review column total formulas in WPS SpreadsheetsCompatible with Microsoft Excel XLS and XLSX formatsFamiliar interface for an easier transition from ExcelFree and lightweight for everyday spreadsheet work
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel total update only when I recalculate?

Excel may be set to Manual calculation. Open File > Options > Formulas and set Workbook Calculation to Automatic.

What does Shift+F9 recalculate in Excel?

Shift+F9 recalculates the active worksheet. To recalculate formulas in all open workbooks, press F9.

What should I check if the total still does not change?

Select the total cell and inspect its formula in the formula bar. Make sure the changed cell is included in the referenced range and that the entry is a number.

Can WPS Spreadsheets open my Excel workbook?

Yes. WPS Spreadsheets can open Microsoft Excel XLS and XLSX files. In WPS Office, select Open and choose the workbook.