Excel Totals Only Update With F9: Restoring Automatic Calculation

You change an order quantity, but its amount stays the same. F9 fixes it. Change another quantity, and you need F9 again. That pattern is a reason to check whether Excel is currently using Manual calculation. A successful recalculation updates the result now; it does not change how Excel handles your next edit.

If Automatic is already selected, look at the formula in the cell that has stopped changing. It may refer to a different row, or its total may exclude the rows you just added. Recalculating the same formula will not correct those references. Compare the cells you edited with the addresses in the formula bar before changing the setting again.

Why your report can open in Manual

A workbook saved with Automatic calculation can nevertheless open in Manual. In a single Excel instance, the first workbook establishes the mode that later workbooks use. Microsoft's explanation of calculation modes also says that changing the mode affects the other open workbooks. Separate workbook windows do not necessarily mean separate calculation settings.

Consider two ordinary files: a large cost model saved in Manual and a daily sales report saved in Automatic. After starting Excel, opening the cost model first puts both files in Manual when you subsequently open the report. Reverse the order, and both use Automatic.

In Excel for Windows desktop—Microsoft 365, Excel 2024, or Excel 2021—select File → Options → Formulas → Workbook Calculation → Automatic to restore automatic updates. The ribbon also offers Formulas → Calculation Options → Automatic. Both routes appear in Microsoft's recalculation settings guide. Switching modes can trigger work in other open files, including a large model deliberately kept in Manual. Save your work and close unrelated files before changing that shared setting.

Saving a workbook stores its current mode. If you want the sales report to start in Automatic when opened first next time, save it after restoring that mode and checking its results. The calculation performance documentation excludes templates and add-ins from the ordinary first-workbook rule. Excel for the web also differs: its calculation option affects only the current workbook, according to the settings guide.

Test the next edit, not just one recalculation

Add a blank worksheet to a copy of the workbook for a small check. Enter quantity 3 in B2, price 120 in C2, and =B2*C2 in D2. The amount is 360. Change B2 to 5: the expected result is 600. If you must press F9 to get 600, do not stop the check there.

Change B2 again, this time to 4. Does D2 become 480 without another calculation command? That second edit tells you whether subsequent changes are being handled automatically. If the cell stays at 600, the earlier F9 only caught up with the previous input. Restore Automatic and repeat the edit.

Re-entering a formula can also make its result update in Manual mode, as the calculation performance documentation explains. An F2-and-Enter fix therefore does not establish that future input changes will calculate automatically. If this new worksheet responds correctly while the original report does not, inspect the original formula and its references using the sections below.

Windows command	Scope
F9	Changed formulas and their dependents across open workbooks
Shift + F9	Changed formulas and their dependents on the active worksheet
Ctrl + Alt + F9	All formulas in all open workbooks, whether changed or not

None of these commands switches the calculation mode to Automatic. For a report that combines several sheets, recalculating only the active sheet is also a narrower operation than recalculating across the workbook. A full recalculation still cannot correct a formula pointing at the wrong row.

Leave formula-editing mode before using F9 this way. While editing, selecting part of a formula and pressing F9 evaluates that expression. If you entered that state accidentally, use Esc to cancel the edit. You can use Formulas → Calculate Now when your keyboard's function keys perform hardware controls instead.

Saving is not a reliable substitute for this check. Manual mode has a separate Recalculate workbook before saving checkbox, which can be cleared. A correct result immediately after saving does not prove that your next input will update it. Remove the temporary worksheet before delivering the report, then check a real changed row and the final total.

When Excel is displaying text instead of calculating

Select the problem cell and inspect the formula bar. If it contains only 360, the cell currently holds a value, not a formula linked to your inputs. Compare it with the intended formula or a previous version. Calculation options cannot reconstruct a formula replaced by a pasted value.

If many cells show expressions such as =B2*C2, check Formulas → Show Formulas. Microsoft's display instructions describe this as a way to view formulas instead of results. Turn it off to return to results. That display change does not enable automatic calculation.

When just one cell keeps showing its formula as text, inspect its number format. For a formula entered into a Text-formatted cell, Microsoft recommends changing the format to General, then pressing F2 and Enter to re-enter the formula. In Windows, Ctrl + 1 opens Format Cells. The re-entry step is part of the documented fix; changing the format alone is not the complete operation.

Also check for a leading apostrophe or a missing equals sign. '=B2*C2 is text, and B2*C2 without the equals sign is not the multiplication formula you intended. Microsoft's formula error guide covers these input problems. Correct the intended formula cell, not an entire neighboring identifier column: a code such as 00125 may need its leading zeros.

Automatic is on, but the result is still wrong

In a Microsoft community question, a user reported outdated links between sheets in the same workbook despite trying F9 and checking Automatic. When those steps make no difference, select one incorrect result and trace the cells feeding it. This gives you a specific formula to investigate instead of recalculating the whole workbook again.

For example, editing B3 will not affect =B2*C2. Similarly, a new value in D10 will not enter a total whose formula is =SUM(D2:D9). Read the addresses in the formula bar and compare them with the cells you changed. If individual row amounts update but the final total does not, start with that total's range.

A circular reference can leave a zero or the last calculated value visible, as Microsoft's circular-reference guidance explains. Suppose D5 contains =SUM(D2:D5). It includes itself. If the intended items occupy D2 through D4, use =SUM(D2:D4) instead.

Open Formulas → Error Checking → Circular References and follow the listed cell addresses. A loop can also run through several intermediate formulas. Do not enable iterative calculation just to suppress a warning in an ordinary sales total; fix the unintended loop. Iteration belongs to models deliberately designed to recalculate circular relationships.

Get the new data before checking the total

A correctly calculating report can still contain old information. If the imported order table stops at this morning's transactions, recalculating it cannot add an afternoon order that Excel has not received. Check whether the missing transaction exists in the imported rows before changing the total formula.

For a workbook with an external data connection, use Data → Refresh All. Microsoft's refresh guidance describes retrieving data through the configured connection. Wait for background refresh to finish and address any connection or sign-in error. If you intentionally retain Manual calculation, recalculate after the fresh data arrives.

Trace one expected order through the result: its identifier should appear in the imported table, its amount should enter the appropriate row calculation, and that row should fall inside the final sum. This gives you a specific place to investigate when the overall total differs from the source system.

If you need a colleague's help, send the cell addresses, formula, and observed behavior: “B2 changed from 3 to 5; D2 stayed at 360 until F9, then became 600; calculation currently says Manual.” If F9 did nothing and Automatic was already selected, include those facts instead. The next person can start with the calculation setting, reference, or connection that your observations actually implicate.