Excel Formula Not Calculating? How to Fix It

A formula that stops updating in Excel is not necessarily broken. Sometimes the workbook is set to Manual calculation. Other times, Excel is treating the formula as text or reading the values it refers to incorrectly.

Start with one small test before changing multiple settings. It will tell you which problem you’re dealing with.

First, check whether Excel can calculate a simple formula

1. Click an empty cell in the same workbook.
2. Set its number format to General from Home > Number Format.
3. Type =2+2 and press Enter.

The result should be 4.

• You see =2+2 instead of 4: Check Show Formulas, Text formatting and a possible leading apostrophe.
• You see 4, but existing formulas aren’t changing: Check Calculation Options and the cells those formulas reference.
• You see an error or an unexpected number in a particular formula: Examine its references, input values and syntax.

This test isolates a basic formula-entry problem from a calculation problem. It does not prove that every complex formula in the workbook is correct.

Formula result not updating? Turn on Automatic calculation

A common symptom is a total that stays at 250 even after you change one of the numbers it adds. Excel may be waiting for you to recalculate the workbook.

In Excel for Windows:

1. Open the workbook.
2. Select the Formulas tab.
3. Select Calculation Options.
4. Choose Automatic.
5. Change a value used by the formula and check whether the result updates.

You can also find this setting through File > Options > Formulas > Workbook Calculation > Automatic.

To update results immediately, select Formulas > Calculate Now, or press F9 in desktop Excel. F9 recalculates formulas, but it does not fix incorrect cell references or text-formatted inputs.

Important: In desktop Excel, changing the calculation mode can affect all workbooks that are currently open. Check whether another spreadsheet intentionally uses Manual mode before making the change. Automatic is normally the appropriate setting for everyday worksheets.

A separate clue is a number with a strikethrough in some recent Microsoft 365 versions. That can indicate a stale formula result waiting for recalculation, rather than a cell someone deliberately formatted with a line through it.

Excel showing the formula instead of the result

Seeing =SUM(B2:B8) written across a cell rather than a number usually points to a display or cell-format issue.

Turn off Show Formulas

1. Open the Formulas tab.
2. Find Show Formulas in the Formula Auditing group.
3. Click it if it is enabled.

On Windows, Ctrl + ` (the grave-accent key, usually above Tab) toggles the same option. When Show Formulas is on, many formula cells display their expressions at once and column widths may expand. Turning it off restores the calculated-value view.

Change a formula cell from Text to General

When only one cell or a small group displays formulas as text, check the number format:

1. Select the affected cell.
2. On the Home tab, change Number Format from Text to General.
3. Double-click the cell, or press F2 in Excel for Windows, then press Enter to re-enter the formula.

Changing the number format alone may not be enough. Re-entering the formula makes Excel interpret it again.

Also look at the formula bar for a leading apostrophe, such as '=A2+B2. That apostrophe tells Excel to treat the following characters as text. Remove it if you intended a formula, then press Enter.

Don’t change an entire imported column to General without checking it first. Product IDs, ZIP codes and account numbers may contain leading zeros that should stay as text.

Formula calculates, but the total is wrong

Suppose =SUM(C2:C6) returns 40 when you expected 65. Excel might be calculating correctly using only the cells it recognizes as numbers.

Check for numbers stored as text

Numbers pasted from a website, exported from a database or imported from a CSV can look numeric while actually being text. The SUM function ignores text entries in a referenced range.

Select one of the suspect cells. A green warning indicator may offer Convert to Number. Use that option only for values that are supposed to be numbers. You can also compare a suspect cell with a known numeric cell by testing =ISNUMBER(C2) in an empty cell. FALSE means the referenced entry isn’t stored as a number.

After conversion, check the total again. Don’t convert identifiers or codes simply to make an Excel warning disappear.

Check which cells the formula uses

Click the result cell and inspect the formula bar. A formula such as =SUM(C2:C6) won’t include a new value entered in C7.

For copied formulas, pay attention to dollar signs. =$C$2*D2 intentionally keeps the first reference fixed when copied down. An accidentally fixed reference can make several rows appear to calculate the same result. Compare a working row with the affected one before changing it.

Duplicate records can also make an otherwise correct total look inflated. That is a data issue, not a failed calculation. For repeated rows, see our guide on how to remove duplicates in Excel.

Only one formula fails? Look for an error or circular reference

When most formulas work, don’t change the whole workbook’s calculation mode again. Investigate the affected cell.

Common results offer clues:

• #REF! means a reference is invalid, often because a referenced row, column or cell was deleted.
• #VALUE! can mean the formula is trying to calculate using an incompatible value, such as text where a number is required.
• #NAME? can indicate an unrecognized function name, named range or misspelled function.
• #DIV/0! means a formula is dividing by zero or by an empty referenced cell.

A circular reference is different: a formula directly or indirectly depends on its own result. For example, placing =SUM(A1:A5) in A5 makes the formula include itself.

In desktop Excel, go to Formulas > Error Checking > Circular References to locate the affected cell. Correct the range or move the formula. Don’t enable iterative calculation simply to silence the warning unless the workbook deliberately uses an iterative model.

For a complex formula, Formulas > Evaluate Formula (where available) can help inspect calculations one part at a time. Review what the formula should do before editing it.

What about Excel on Mac or Excel for the web?

The underlying causes are similar, but the menu paths differ:

• Excel on Mac: Open the Excel menu, select Preferences > Calculation, and check that Automatic is selected. The calculation and auditing controls may also appear on the Formulas ribbon, depending on your version.
• Excel for the web: Open Formulas > Calculation Options > Automatic. When available, Calculate Workbook can refresh results. A calculation-mode change in the web version applies to the current workbook rather than all desktop workbooks.

The exact labels may vary across Microsoft 365 builds. On any platform, the distinction between a formula displayed as text and a formula showing an old result remains the most useful starting point.

Still not calculating? Compare with a fresh workbook

Save a copy of the affected workbook first. Then create a blank workbook and enter =2+2 in a General-formatted cell.

If the new workbook calculates normally but the old one does not, concentrate on the original file’s calculation mode, formulas, formatting or imported data. Check a simple failing formula before making bulk changes. Avoid replacing all formulas with values, since that permanently removes the live calculations.

If even the new workbook cannot calculate =2+2, make sure you entered the equals sign, check whether Show Formulas is enabled and confirm the cell isn’t formatted as Text. Restart Excel only after those checks.

For further reference, Microsoft’s guides on broken formulas and formula recalculation settings document the relevant settings and platform differences.