← Back to Error Directory

Excel Formulas Not Calculating? Here's the Real Fix

Not an error code — a silent failure where your numbers just stop updating. Here's every cause, starting with the most common one people miss.

Table of Contents

1. Why This Is Worse Than a Visible Error

Every error covered elsewhere on this site at least tells you something is wrong — a #VALUE! or #REF! gives you a clear starting point. A formula that simply refuses to recalculate is more dangerous precisely because it looks fine. The cell shows a number, it just happens to be the old number from before your data changed, and nothing on screen signals that anything is stale.

2. Interactive Demo: Calculation Mode Simulator

See how changing an input cell behaves completely differently depending on calculation mode.

Formula in B1: =A1*2

B1 shows: 200

Switch to "Manual" mode and change A1 — notice B1 no longer updates until you explicitly press the F9 button, exactly like real Excel.

3. Cause 1: Calculation Mode Set to Manual

By far the most common cause. Somewhere along the way — often from opening a workbook that someone else configured, or from a macro that changed the setting programmatically — Excel's calculation mode gets switched from Automatic to Manual. In Manual mode, formulas only recalculate when you explicitly trigger it (F9), not whenever an input changes.

Fix: Go to Formulas tab → Calculation Options (in the Calculation group) → select Automatic.

4. Cause 2: Cell Formatted as Text

If a cell was formatted as Text before a formula was typed into it, Excel treats the entire entry — including the leading equals sign — as literal text rather than an instruction to calculate. The cell will display the formula itself, like =A1*2, rather than a computed number.

Fix: Select the cell, change its format to General or Number (Home tab → Number Format dropdown), then re-enter the formula (simply changing the format after the fact isn't enough — you need to retype or re-confirm the formula for Excel to reinterpret it).

5. Cause 3: Show Formulas Mode Accidentally Enabled

Pressing Ctrl+` (the backtick/grave accent key, usually above Tab) toggles a workbook-wide "Show Formulas" view, displaying every formula's underlying text instead of its calculated result across the entire sheet. This is easy to trigger accidentally and easy to mistake for a genuine calculation failure, since every formula in the workbook appears simultaneously "broken" the same way.

Fix: Press Ctrl+` again to toggle it back off, or check Formulas tab → Show Formulas button state directly.

6. Cause 4: An Unrelated Circular Reference Blocking Calculation

If any cell in the workbook contains an unresolved circular reference (see our circular reference guide), Excel's calculation engine can, in some cases, halt broader recalculation until that specific issue is addressed, making otherwise-unrelated formulas elsewhere in the workbook appear frozen or unresponsive.

7. Cause 5: Iterative Calculation Settings Interfering

If iterative calculation is enabled with a very high maximum iteration count and a very tight maximum change threshold, large workbooks with many interdependent formulas can take noticeably longer to fully settle after any change, giving the impression that formulas aren't updating when they're actually still working through the iteration process in the background.

If formulas reference an external workbook that's been moved, renamed, or is simply closed, Excel may show the last cached value rather than a live recalculation, since it can't retrieve fresh data from a source it can't currently reach. This can look identical to a general "formulas not calculating" problem but is actually specific to the external reference — see our #GETTING_DATA guide for the related loading-state behavior.

9. Forcing a Full Recalculation

ShortcutWhat it does
F9Recalculates all formulas in all open workbooks that Excel has flagged as needing an update
Shift+F9Recalculates only the active worksheet
Ctrl+Alt+F9Forces a full recalculation of every formula in every open workbook, regardless of whether Excel thinks it's needed — the "nuclear option" for stubborn stale values
Ctrl+Shift+Alt+F9Rebuilds the entire dependency tree from scratch before recalculating — reserved for genuinely corrupted calculation chains

10. Google Sheets Equivalent Behavior

Google Sheets does not have a persistent Manual calculation mode the way Excel does — it recalculates automatically by default in nearly all situations. The closest equivalent issue in Sheets is a custom function (Apps Script) that hasn't finished executing, or an IMPORTRANGE/IMPORTDATA connection that's temporarily stale — press Ctrl+Alt+Shift+F9 in Sheets as the rough equivalent of Excel's forced full recalculation shortcut.

11. Frequently Asked Questions

Why are my Excel formulas not updating automatically?

The most common cause is Excel's calculation mode being set to Manual instead of Automatic. Go to Formulas tab, Calculation Options, and confirm Automatic is selected. If it's already Automatic, the cell may be formatted as Text, which prevents formula evaluation entirely.

How do I force Excel to recalculate everything?

Press F9 to recalculate all open workbooks, or Ctrl+Alt+F9 to force a full recalculation of every formula regardless of whether Excel thinks it needs updating, which is useful when values seem stuck even after F9.

Why does a formula show the formula text instead of the calculated result?

This happens when the cell is formatted as Text before the formula is entered, or when Show Formulas mode is accidentally toggled on. Change the cell format to General or Number, then re-enter the formula, or press Ctrl+` to toggle Show Formulas off.

Related Guides

Editorial Disclaimer: This guide is developed to the best of our domain knowledge and tested against Excel 2019+, Microsoft 365, and Google Sheets. Content is updated continuously as spreadsheet calculation engines evolve.