Fix an Excel Column Total That Does Not Recalculate Automatically
Question details
The user needs an Excel column total to update automatically when a number in the column changes.

- 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.
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.
Recalculate the Worksheet and Enable Automatic Calculation in Excel
Use this method to check whether Manual calculation is preventing the total from updating.
Select the worksheet containing the total and press Shift+F9 to recalculate it. Check whether the total updates.
In Excel, select File > Options > Formulas.
Under Calculation options, set Workbook Calculation to Automatic, then select OK.
Change a number included in the total formula and confirm that the total updates automatically.

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.

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.




