Excel Formulas Not Updating Automatically

What this does

A formula that displays its own text, or a number that never updates, has one of four causes and they are worth checking in order: calculation is set to Manual; the cell was formatted as Text before the formula was typed, so Excel stored it as a string; Show Formulas is toggled on for the whole sheet; or the entry begins with a stray apostrophe that forces it to be treated as text. Before changing anything, confirm the symptom is reproducible — in another sheet, another file or after reopening — so you know whether the cause is local to this workbook. Treat “excel formulas not updating automatically” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected formula shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a workflow that saves repeating the same clicks every week into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

C2 shows =B2*1.2 instead of 60. The Number group reads Text. Set it to General, press F2 then Enter to re-commit the entry, and the cell displays 60. Applying General alone changes nothing — the stored value is still a string until the cell is re-entered. Every one of these failures looks like a broken formula and none of them is, so the time is lost rewriting a formula that was correct all along. Change one thing at a time and re-check the symptom after each step, so you know which fix actually worked.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. Treat “excel formulas not updating automatically” as a diagnosis rather than a fix to copy: the right step depends on which cause applies, so check before you change.

Common mistakes

• Setting the cell to General and expecting it to calculate without re-entering — the format change alone does not re-parse the stored text.
• Leaving calculation on Manual for one heavy workbook and not noticing that the mode applies to every file opened in that session.
• Ignoring the word Calculate in the status bar, which is Excel saying results on screen are out of date.
• Deleting and retyping the formula in a cell that is still formatted as Text, which reproduces the problem exactly.

Frequently asked questions