Excel Formula Not Calculating? 6 Causes and How to Fix Them

1. Manual Calculation Mode Is On

This is by far the most common cause. Excel has two calculation modes: Automatic (formulas update whenever any cell changes) and Manual (formulas only update when you press F9). Manual mode is often switched on accidentally — or inherited from a workbook that someone else set up.

How to check: Go to Formulas → Calculation Options. If it says "Manual", that is your problem.

Fix: Click Formulas → Calculation Options → Automatic. All formulas will immediately recalculate. Alternatively, press Ctrl+Alt+F9 to force a full recalculation of every formula in the workbook.

2. The Cell Is Formatted as Text

If a cell is formatted as Text before you type a formula, Excel treats everything typed into it as a literal text string — even if it starts with =. The formula will appear as text in the cell rather than calculating.

How to spot it: The cell shows the formula text (e.g., =SUM(A1:A10)) instead of a result. In the Number Format box on the Home tab, it likely says "Text".

Fix: Select the cell → change the format from Text to General (Home → Number Format dropdown → General). Then double-click the cell and press Enter to re-enter the formula. Excel will now calculate it.

3. Show Formulas Mode Is Enabled

Excel has a "Show Formulas" view that displays the formula text in every cell instead of the calculated result. This is useful for auditing, but if it is turned on accidentally the entire sheet looks like formulas are not working.

How to check: Look at the Formulas tab — if "Show Formulas" is highlighted, it is active.

Fix: Click Formulas → Show Formulas (to toggle it off). Or press Ctrl+` (the backtick key, usually top-left of the keyboard). The sheet will immediately switch back to showing calculated values.

4. The Formula Contains a Circular Reference

A circular reference occurs when a formula refers to its own cell — either directly (=A1+1 in cell A1) or indirectly (A1 references B1, B1 references A1). Excel cannot calculate an infinite loop, so it either returns 0 or uses the last calculated value.

How to check: Go to Formulas → Error Checking → Circular References. If any cells are listed, those are the problem cells.

Fix: Click the cell in the Circular References list. Examine the formula and identify which reference creates the loop. Usually it means a formula range is one row too large and is inadvertently including the formula cell itself — for example, =SUM(A1:A10) typed in cell A10.

5. Iterative Calculation Is Enabled

Iterative calculation is a setting that allows circular references to calculate a fixed number of times (default: 100 iterations). It is sometimes enabled intentionally for financial models, but when enabled accidentally it can cause formulas that should be simple to return unexpected results.

How to check: File → Options → Formulas → look for "Enable iterative calculation".

Fix: If you did not intentionally enable this, uncheck "Enable iterative calculation" and click OK. Then fix any circular references that may have been masked by this setting.

6. The Formula References an Empty or Error Cell

A formula that depends on a cell containing an error (#REF!, #VALUE!, #N/A) will also return an error — even if the formula itself is correct. Similarly, a SUM that references only empty cells will return 0, which may look like it is not calculating.

Fix: Use Formulas → Trace Precedents to find which cells the formula depends on. Fix any errors in those upstream cells. Wrap the formula with IFERROR to handle upstream errors gracefully: =IFERROR(your_formula, "").

Quick Diagnostic Checklist

Run a Full Formula Audit

If your workbook has multiple formulas not calculating correctly and you need to find them all at once, the ExcelErrorFinder audit tool scans every cell in your spreadsheet and flags error cells, circular reference patterns, text-formatted numbers, and more — with exact cell addresses and step-by-step fixes.