Excel Auto Calculate: Why Formulas Stop Updating

You change a number in one cell and the total three rows down does not move. The usual cause is not a broken formula — it is that the workbook’s calculation mode has been set to Manual, so Excel is deliberately not recalculating until you tell it to. That setting travels with the file, so it can arrive already set by whoever last saved it, not by anything you did.

Why it happens

Excel has three calculation modes: Automatic (recalculates on every change), Automatic Except for Data Tables (the same, but skips the slow recalculation of data tables), and Manual (recalculates only when you ask). Manual mode exists for a real reason — a workbook with thousands of formulas or a heavy data table can lag badly if it tries to recalculate on every keystroke, so some large financial models are deliberately built in Manual mode on purpose.

What catches people out is that the setting is stored with the file, not with your own Excel installation. Open a workbook someone else built and saved in Manual mode, and your copy opens in Manual mode too, with no warning banner telling you so.

Fix it in under a minute

1. 01Open the Formulas tab and look at Calculation Options. If it says Manual, that is almost certainly your answer.
2. 02Switch it to Automatic, unless the workbook is genuinely large and slow, in which case Automatic Except for Data Tables is the safer middle option.
3. 03Before trusting any number already on screen, force one recalculation: F9 recalculates every open workbook, Shift+F9 recalculates only the active sheet. Do this once after switching modes, because a result calculated under Manual mode can be stale even after you flip the setting.
4. 04If a large workbook grinds every time you type once it is back in Automatic, that slowdown is the actual tradeoff Manual mode exists to avoid — it is not a sign anything is broken.

Where asking AI helps, and where it cannot

A general assistant is genuinely useful for the first part of this: asking "why would my Excel formulas stop updating when I change a cell" gets back the calculation-mode explanation and the exact menu path and shortcuts, which is faster than hunting through a ribbon you do not use often. OpenAI’s and Anthropic’s own prompting guidance both make the same point for any task: naming the exact symptom — "changed B2, total in B20 did not change" rather than "Excel is broken" — gets a usable answer back on the first try instead of a generic list of five unrelated causes. Pasting the actual calculation-mode setting and the exact formula involved, rather than describing the workbook from memory, narrows that answer down further still.

What it cannot do is open your workbook and flip the setting for you, or know which of the several possible causes below is actually the one in your file. A widely cited survey of hallucination in large language models covers why a model can list a plausible cause with complete confidence without having seen your sheet at all — it is guessing from the symptom you described, not reading the file.

Ask AI to explain why a formula might not be updating. Check the calculation mode in your own file. Force one recalculation before you trust any number already on screen.

When it is not the calculation mode

If Calculation Options already says Automatic and the number still will not move, the cause is usually one of these instead:

• —A circular reference — the status bar shows a warning, and the cell involved returns 0 or the last value it calculated before Excel gave up.
• —The number is formatted as text, not a number — it left-aligns instead of right-aligning, and a formula referencing it returns an error or treats it as zero.
• —A link to another, closed workbook that has not refreshed. Excel shows cached values from the last time that link was open, which look fine until the source file changes.
• —Rows were inserted or deleted and a formula’s range did not expand to match, so it is quietly summing the old range rather than the new one.
• —A filter or hidden rows are affecting what a function like SUBTOTAL or AGGREGATE reports, which is correct behaviour for those functions but easy to mistake for a stuck calculation.

Each of those produces the same visible symptom — a number that will not change — for a different reason, which is exactly why naming the specific symptom to an AI tool, rather than just "my formulas are not updating," narrows down which of the five it is likely to be. How to Write Better AI Prompts covers that habit for any spreadsheet question, not just this one.

What to do Monday

1. 01Check Formulas > Calculation Options first, every time a total looks stuck. It is the single most common cause and the fastest to rule out.
2. 02Force a recalculation with F9 before you trust a number that was on screen before you checked the mode.
3. 03If the mode was already Automatic, work through the list above rather than assuming the file is simply broken.
4. 04For a formula that calculates but returns the wrong thing rather than a stale one, Excel Errors covers what each error code is actually telling you, and Excel Lookup Formula and Difference in an Excel Formula cover two of the most common formulas to get quietly wrong once the sheet is calculating correctly again.

Deciding in advance what you would check before trusting a number, rather than discovering the gap once a wrong total has already gone into a report, is the same habit behind NIST’s AI Risk Management Framework, scaled down here to one workbook instead of a deployed system. Excel Shortcut covers how to get the exact keyboard shortcut you need from an AI tool rather than a list of forty, and Stock Inventory Management in Excel is a worked example of a workbook where a stuck calculation mode would be easy to miss until a reorder flag was already wrong.

The short version

A total that will not move after you change a cell is almost always the calculation mode, and checking it takes under a minute. If the mode is already Automatic, the real cause is on the list above, not a mystery. Either way, force a recalculation before you trust a number that was already on screen when you started looking.

Coursium teaches that same habit — asking a precise question, and checking the answer before you trust it. Stay ahead of AI by learning the tools on your phone.