Excel Formula Not Updating? 7 Fixes for Calculation Problems

If an Excel formula does not update after you change a value, first check calculation mode. In the desktop app, choose Formulas > Calculation Options > Automatic, then press F9 to recalculate.

If that does not solve it, the formula may be displayed as text, refer to the wrong cell, contain an error, or use an input Excel does not recognize as a number. The checks below help you identify the cause without rebuilding the worksheet.

Quick diagnosis: why is an Excel formula not updating?

1. Turn on Automatic calculation

Excel normally recalculates formulas when a referenced value changes. If calculation is set to Manual, a formula can keep showing an old result until you calculate the workbook yourself.

In Excel for Windows desktop, select Formulas > Calculation Options > Automatic. You can also go to File > Options > Formulas and choose Automatic under Workbook Calculation.

Then press F9. This asks Excel to recalculate open worksheets. If the result changes now, Manual calculation mode was the cause.

For example, the tax formula below should change whenever the invoice amount changes:

=B5*$F$5

Calculation settings can affect more than one open workbook in the desktop app. If a workbook suddenly stops updating after you open another file, check this setting first.

2. Check whether Excel is displaying formulas instead of results

If every formula is visible in its cell instead of its result, Show Formulas may be turned on. Select Formulas > Show Formulas to switch it off. On Windows, the shortcut is Ctrl + ` (the grave-accent key).

This mode is useful for auditing formulas, but it does not mean the formulas are broken. Turn it off to return to the normal results view.

3. Fix a formula that Excel treats as text

If only one or a few cells show a formula such as =B5*$F$5 instead of a number, Excel may be treating the entry as text. A leading apostrophe, a leading space, or a Text cell format can cause this.

1. Select the problem cell.
2. On the Home tab, change the Number Format to General.
3. Press F2, then press Enter.

Pressing F2 and then Enter makes Excel read the existing entry again. If it begins with an equals sign and the cell is not text-formatted, Excel calculates it as a formula.

4. Look for an error before trying to hide it

An error value is Excel’s way of telling you that the formula cannot return a valid result. The correct fix depends on the error:

• #REF! means the formula refers to a cell, range, sheet, or workbook reference that is no longer valid.
• #VALUE! often means a function received the wrong type of input, such as text where it expects a number.
• #DIV/0! means a formula is dividing by zero or by a blank cell.
• #NAME? usually means Excel does not recognize part of the formula, such as a misspelled function name.

Select the error cell and read the formula bar. Correct the reference or input first. Do not add IFERROR just to remove the message, because that can hide a problem that still affects the workbook.

For code-by-code causes and safe first fixes, read Excel Formula Errors Explained: #N/A, #VALUE!, #REF!, and More.

5. Compare a formula with the rows around it

A formula can calculate successfully and still return the wrong answer. This often happens after a formula is copied or edited in one row.

For a sales total, the correct pattern is:

D5: =B5*C5
D6: =B6*C6
D7: =B7*C7

If D6 contains =B6*C5, the formula uses the price from the row above. It may return a number, but it is not the right number.

Use Formulas > Show Formulas when you need to compare several formulas at once. Then inspect the row and column parts of each reference carefully. Our guide to relative, absolute, and mixed cell references explains why those references change when a formula is copied.

6. Check whether a number is stored as text

When a value looks like a number but is stored as text, a formula may return #VALUE!, zero, or an unexpected result. This often happens after data is pasted from another system.

Select the input cell and look for a warning indicator. You can also test it with:

=ISNUMBER(A2)

If the result is FALSE, convert the value only after checking what the original data represents. For a simple imported number, select the cells, choose a numeric format, and use Data > Text to Columns > Finish. This prompts Excel to re-evaluate the selected values.

7. Check for a circular reference

A circular reference occurs when a formula refers to its own cell, directly or through another formula. For example, entering =A1+1 in A1 creates a circular reference.

Look for Excel’s circular-reference warning and trace the affected formula back to its inputs. Iterative calculation is useful for specific financial or engineering models, but it is not the usual fix for an accidental circular reference.

What to do when F9 does not fix the formula

If pressing F9 does not change the result, the issue is probably not calculation mode. Work through this order:

1. Check whether the cell contains a real formula or text.
2. Check for an error value and correct its cause.
3. Compare the formula with a correct neighboring formula.
4. Confirm that referenced inputs are numbers, dates, or text in the format the formula expects.
5. Check for a circular reference if Excel reports one.

This sequence is faster and safer than rewriting a formula immediately. It lets you identify whether the problem is the calculation setting, the formula itself, or the data it uses.

Source and further reading

Microsoft explains how to change formula recalculation, iteration, or precision, avoid broken formulas, and show or hide formulas.

To learn how The Excel Guide researches, tests, and updates its tutorials, read our Editorial Policy.