Excel Formulas Not Updating? Start Here, Not With F9

First thing: check the Calculation Mode

What's actually happening here is Excel switched to Manual calculation mode. This happens more often than you'd think — maybe you accidentally hit F9 while trying to do something else, or a macro or add-in flipped the setting. When Excel's in Manual mode, it only recalculates when you explicitly press F9 (Calculate Now) or Shift+F9 (calculate active sheet). You change a value, you expect the formula to update, but nothing happens. The cell still shows the old result.

Here's how to fix it:

1. Go to the Formulas tab on the ribbon.
2. Look at the Calculation Options button in the Calculation group.
3. If it says Manual, click it and select Automatic.
4. Wait a second — Excel should flash through all your formulas and update them.

If you're on Excel for Mac, it's under Formulas > Calculation Options too, or you can go to Excel > Preferences > Calculation and check the Automatic radio button.

The reason step 3 works is because Excel recalculates every formula in the workbook the moment you switch back to Automatic mode. It doesn't need a manual refresh after that — it'll update on every cell change from now on. But if you're in a workbook with thousands of formulas and you want to keep Manual mode for performance, at least now you know why it wasn't updating.

Second culprit: a circular reference is blocking recalculation

Here's a scenario most people don't expect: you have a formula that references itself, even indirectly. Excel detects this and, by default, stops recalculating entirely for that workbook. You'll see a warning in the status bar at the bottom left: Circular References with a cell address next to it. But here's the catch — if the circular reference is on a different worksheet, or if you didn't notice the warning, Excel will just silently stop updating formulas. You change a dependent cell and nothing happens. No error message, no warning sound. Just stale numbers.

To find and fix it:

1. Look at the bottom-left of the Excel window. If you see Circular References followed by a cell address (like $C$10), that's your culprit.
2. Go to the Formulas tab, click the Error Checking dropdown (it's next to the Error Checking button with the yellow diamond), then choose Circular References. A submenu will list all circular references in the workbook.
3. Double-click on each one to jump to that cell. Inspect the formula — it will contain its own cell address or a chain that eventually comes back to it.
4. Fix the formula. Common ways: remove the self-reference, or restructure the calculation to avoid the loop. If you intentionally need iterative calculation (e.g., for convergence), go to File > Options > Formulas and enable Enable iterative calculation. But I'd only do that if you know what you're doing — it can mask real logic errors.

One real-world scenario where this bit me: I had a column that calculated total cost = quantity * unit price, then another column that added shipping. Shipping was calculated as a percentage of total cost, and somewhere I'd accidentally included the shipping cell in the total cost formula. Stupid, but easy to miss in a big sheet.

Third cause: the worksheet(s) are set to not recalculate

This one's rarer, but it lives in VBA territory. Someone (or a macro) might have set the worksheet's EnableCalculation property to False. When that's done, even with Automatic mode on, formulas on that sheet won't update. You'll change a cell, and the dependent formulas stay frozen. This doesn't show up in the UI at all — no warnings, no status bar messages. The only way to detect it is via the VBA editor.

To check and fix:

1. Press Alt+F11 to open the VBA editor.
2. In the Project Explorer (left pane), find your workbook and expand it. You'll see all worksheets listed under Microsoft Excel Objects.
3. Click on the first worksheet. In the Properties window (bottom-left, usually), look for EnableCalculation. If it's set to False, change it to True.
4. Repeat for every worksheet in the workbook. You can select multiple by holding Ctrl and clicking each one, then change the property for all at once.
5. Close the VBA editor. Your formulas should start updating immediately.

How does this happen in practice? Mostly from old macros that people wrote years ago to freeze a sheet during data entry. The macro sets Sheet1.EnableCalculation = False at the start and never sets it back to True. Or from corrupted template files. If you inherited the workbook from someone else, this is worth checking.

Quick-reference summary table

If none of these fixed it, you might have a volatile function problem (unlikely — volatile functions always update) or a multi-user workbook with sharing enabled (which limits recalculation). But 9 times out of 10, it's one of the three above. Start with Automatic mode, then hunt for circular references, then look at VBA. You'll save yourself the frustration of hitting F9 a hundred times.