Excel Not Auto Updating Formulas? Fix It Now

Errors & fixes · Updated November 22, 2026

If your Excel formulas are not auto-updating, the most likely cause is that calculation is set to Manual instead of Automatic. Press F9 (Windows) or Cmd + = (Mac) to recalculate now, then change the setting back to Automatic via Formulas > Calculation Options > Automatic.

Why Excel Stops Auto-Calculating

Excel normally recalculates every formula whenever a referenced cell changes. However, several settings and conditions can break that automatic behavior:

  • Manual calculation mode – the most common culprit; Excel only recalculates when you press F9, Shift+F9, or Cmd+=.
  • Formulas entered as text – if a formula starts with a space, apostrophe, or is formatted as text, Excel treats it as a literal string and never calculates it.
  • Iterative calculation disabled – for circular references, Excel may stop updating unless iteration is enabled.
  • Broken links or external references – if a formula references a closed workbook, Excel may not update until you open that workbook or update links.
  • Volatile functions not recalculating – some functions like RAND() or NOW() only recalc when the sheet changes, not continuously.

How to Switch Back to Automatic Calculation

Here’s the exact path in Microsoft 365 (Windows):

  1. Go to the Formulas tab on the ribbon.
  2. Click Calculation Options (in the Calculation group).
  3. Select Automatic.

On a Mac, the path is the same: Formulas > Calculation Options > Automatic. In Excel for the web, calculation is always automatic and cannot be changed to manual.

If you prefer keyboard shortcuts: Alt + M + X + A (Windows) sets Automatic, and Alt + M + X + M sets Manual. On Mac, press Cmd + , (comma) to open Excel Preferences, then go to Calculation and select Automatic.

What to Do When F9 Doesn’t Help

If you press F9 and formulas still don’t update, the problem is likely not calculation mode. Check these:

  • Is the cell formatted as Text? Select the cell, go to the Home tab, and in the Number group, change the format from Text to General. Then re-enter the formula by clicking in the formula bar and pressing Enter.
  • Are there leading spaces or apostrophes? Look at the formula bar. If you see a space or an apostrophe before the equals sign, remove it.
  • Is the formula actually a formula? If the cell starts with a number or a letter, it’s not a formula. Re-type it with an equals sign.
  • Are you editing in a table? In an Excel Table, formulas auto-fill, but if you manually typed a formula that doesn’t match the column pattern, it may not recalc. Check the table’s calculated column settings.

Common Misconception: Auto-Calc Means Live Updates

Many users expect formulas to update in real time, like a stock ticker. Excel does not do that by default. Even in Automatic mode, Excel recalculates when:

  • You change a cell value.
  • You open the workbook.
  • You save the workbook (depending on settings).

It does not recalculate every second. If you need a live-updating timestamp, use =NOW() but know it only updates when the sheet recalculates. For true real-time data, you’d need a data connection or VBA.

Volatile Functions and Recalculation

Some functions are volatile, meaning they recalc every time Excel recalculates, even if no input changed. Examples include RAND(), NOW(), TODAY(), OFFSET(), and INDIRECT(). If you use many volatile functions, Excel may slow down, but they will update on every recalc. If you want to force a one-time update, press F9 (or Cmd+= on Mac).

How to Force a Full Recalculation

Sometimes you need a complete rebuild of the calculation chain:

  • F9 – recalculates all open workbooks.
  • Shift+F9 – recalculates only the active sheet.
  • Ctrl+Alt+F9 – forces a full recalculation of all open workbooks, ignoring any dirty marks (Windows only).
  • Ctrl+Shift+Alt+F9 – rebuilds the dependency tree and recalculates everything (Windows only).

On Mac, the equivalents are Cmd+= (calculate all) and Shift+Cmd+= (calculate active sheet). There is no direct Mac equivalent for the Ctrl+Alt+F9 combos, but you can use Tools > Options > Calculation to set manual and then press Cmd+=.

When to Use Manual Calculation

Manual mode is useful for large, slow workbooks. You can set it to Manual, edit many cells, and then press F9 once to recalc. To avoid forgetting, Excel shows “Calculate” in the status bar when manual mode is on and there are uncalculated changes. To turn it back on, use the ribbon path above.

Frequently Asked Questions

Q: Why are my formulas showing the same result after I change a value?
A: Most likely calculation mode is set to Manual. Press F9 to recalc, or change to Automatic as described above. Also check if the cell is formatted as Text.

Q: How do I make Excel recalculate automatically on open?
A: Go to File > Options > Formulas (Windows) or Excel > Preferences > Calculation (Mac). Under “Calculation options,” ensure “Automatic” is selected. Also, check “Recalculate workbook before saving” if you want that.

Q: My formula works in one cell but not when I drag it down. Why?
A: This often happens when the formula contains relative references that change incorrectly. For example, if you want to multiply a fixed cell, use absolute references like $A$1. Also, if the column is formatted as text, dragging may copy text formatting.

Q: Does Excel auto-calculate in Google Sheets?
A: Yes, Google Sheets recalculates automatically and instantly. It does not have a manual calculation mode, but you can use NOW() with a script for periodic updates. In Excel, you have the manual option.

Q: Why is my formula not updating when I open a linked workbook?
A: If your formula references a closed workbook, Excel may not update until you open the source file. To update links, go to Data > Edit Links and choose “Update Values.” Also, ensure that “Ask to update automatic links” is enabled in Excel Options.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.