Why Excel Formulas Are Not Updating (And How to Fix It)

The most common reason Excel formulas are not updating has nothing to do with your formula. The formula is fine. Excel just quietly stopped recalculating it and didn't tell you.

I've been using Excel daily for close to twenty years, first as a staff accountant and then as a financial analyst. In that time, I've seen formula failures cost people hours of work they didn't know they'd lost. A colleague of mine used to spend three hours every Friday copying data by hand because she didn't realize a VLOOKUP could do it in thirty seconds. A stale, non-recalculating formula can be just as invisible and just as costly. This guide covers the one setting you should check first, then walks through the less obvious culprits that tutorials tend to skip.

What You'll Fix, and the One Setting to Check Before You Touch Your Formulas

By the end of this guide, you'll be able to diagnose why your formulas stopped recalculating and restore automatic calculation without breaking anything else in your workbook.

Excel has two main calculation modes: automatic calculation (the default) and manual calculation mode. In automatic mode, every formula recalculates the moment a referenced cell changes. Manual mode freezes everything. Excel holds the last calculated result until you tell it to update. That's the entire mechanic behind Excel formulas not updating. The formula isn't broken. Excel is just waiting for a signal that isn't coming.

Here's the part most articles don't explain: Excel can switch to manual calculation mode without you touching anything. If the first workbook you open in a session was saved in manual mode (a file a colleague sent you, a legacy report from 2019) every other workbook you open that session inherits that setting.

Check your workbook calculation settings before anything else. Everything below follows from that.

---

Step 1: Switch Excel Back to Automatic Calculation So Formulas Update on Every Change

This is the fix in most cases. Two minutes, and it's done.

How to Change Calculation Options in Excel 365, 2019, and Earlier Versions

1. Open the workbook where formulas aren't refreshing.
2. Click the Formulas tab in the ribbon.
3. Click Calculation Options on the right side of the ribbon.
4. Select Automatic.

The path is identical in Microsoft 365, Office 365, and Excel 2019. In older versions like Excel 2016, you can also reach it via File → Options → Formulas → Workbook Calculation → Automatic. Either route gets you to the same setting.

Always save the file immediately after switching. The calculation mode is stored in the workbook itself. If you close without saving, the file still carries the old manual setting and you'll be back here next time you open it.

How to Force a One-Time Recalculation With F9 When You Need Results Right Now

If you're not ready to change the calculation mode globally, or you're working with a large file and want to control when recalculation runs, you can force recalculate Excel manually:

• F9 recalculates all open workbooks.
• Shift + F9 recalculates only the active worksheet.
• Ctrl + Alt + F9 forces a full recalculation of every formula in every open workbook, even if Excel doesn't think the values have changed. Use this when you suspect a deeper sync issue.

Use F9 as a bridge fix, not a long-term solution. If you find yourself pressing it every few minutes, the underlying calculation mode is still set to manual and that needs to be addressed.

---

Step 2: Rule Out the Other Reasons Your Excel Formulas Are Not Updating

Once you've confirmed the calculation mode is set to Automatic and the problem persists, you're dealing with something else. Two culprits cover the vast majority of remaining cases.

Check Whether the Cell Is Formatted as Text

If your formula is displaying as literal text (you can see =SUM(A1:A10) in the cell instead of a result) the cell is formatted as Text. Excel interprets the formula as a string, not as an instruction.

To fix it: select the cell, go to the Home tab, and change the format dropdown from "Text" to "General." Then click into the cell, press F2, and press Enter. That re-triggers the formula entry and forces recalculation. Changing the format alone isn't enough. You have to re-enter the formula for the change to take effect.

This is easy to miss, and it shows up often when data has been imported or pasted from another source. For a broader look at how import issues can create formula problems, the common Excel errors and troubleshooting examples guide covers this in more depth.

Look for a Circular Reference Hiding in the Chain

A circular reference happens when a formula refers (directly or through a chain of other formulas) back to its own cell. Excel can't resolve it, so it stops calculating. You'll often see a warning banner, but not always, especially if iterative calculation is enabled.

Go to Formulas → Error Checking → Circular References. Excel will list the offending cell. From there, trace the cell references back until you find where the loop closes. Fixing a circular reference usually means restructuring the formula logic, not patching the symptom. If you're dealing with a stubborn one, the dedicated guide on fixing circular references in Excel walks through the most common structural causes.

---

Common Mistakes That Keep Excel Formulas From Updating

Switching calculation mode back to Automatic solves the problem in most sessions. These are the cases where it doesn't stick, or where the same problem keeps coming back.

Re-saving in a legacy format. If you save an .xlsx file as .xls (Excel 97–2003), some workbook calculation settings can reset. Always verify calculation mode after a format change.

Upgrading from Excel 2019 to Microsoft 365, or from Windows 10 to Windows 11. In 2026, this is still catching people off guard. When you migrate to a new Excel version, any legacy files set to manual mode carry that setting forward. The first time you open one of those old files in a new environment, it can push your entire session into manual calculation mode silently. If your formulas stopped updating right after an upgrade, this is almost certainly why.

Using Manual mode as a performance tool and forgetting to flip it back. With 50,000-row datasets, automatic recalculation on every keystroke causes real lag. Switching to manual while entering data and pressing Ctrl+Alt+F9 when you're done is a legitimate workflow. The mistake is closing the file before switching back to Automatic. One missed step, and the next person to open it inherits a manual-mode workbook with no idea why nothing's recalculating.

If you're newer to Excel and finding these edge cases confusing, the Excel for Beginners guide builds the conceptual foundation that makes formula behavior easier to reason through, including why calculation mode exists in the first place.

If you take one thing from this article: check your calculation mode first, save the file after you fix it, and remember that the setting lives in the workbook, not just in your current session.

---