Excel Not Calculating Automatically? Fix It Now

Errors & fixes · Updated November 22, 2026

If your Excel workbook isn’t calculating automatically, the most likely cause is that the calculation mode is set to Manual. To fix it, go to Formulas > Calculation Options and select Automatic. If that doesn’t solve it, the issue may be a single cell formatted as text, a circular reference, or a volatile function that isn’t updating as expected.

Why Excel Stops Calculating Automatically

Excel’s default behavior is to recalculate every formula whenever a value it depends on changes. However, several settings and conditions can override this:

  • Calculation mode set to Manual – This is the most common cause. It can be changed accidentally via the ribbon or by opening a workbook that was saved with Manual mode.
  • Cell formatted as Text – If a cell is formatted as text before you enter a formula, Excel treats the formula as a literal string and never calculates it.
  • Circular references – A formula that refers to its own cell (directly or indirectly) triggers a warning and may stop automatic calculation.
  • Volatile functions – Functions like NOW(), TODAY(), RAND(), and OFFSET() recalculate on every change, but they may not update if calculation is set to Manual.
  • Broken links or external references – If a formula references another workbook that is closed, Excel may not recalculate until that workbook is opened.

How to Check and Change Calculation Mode

The quickest way to see the current mode is to look at the status bar at the bottom of the Excel window. If you see the word “Calculate” (with a calculator icon), calculation is set to Manual. To change it:

  1. Click the Formulas tab.
  2. In the Calculation group, click Calculation Options.
  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.

Recalculate Manually When Needed

Even with Automatic mode, you may want to force a recalculation to ensure all formulas are up to date. Use these shortcuts:

  • F9 – Recalculates all formulas in all open workbooks (Windows). On Mac, press Cmd + = or Fn + F9 depending on keyboard settings.
  • Shift + F9 – Recalculates only the active sheet (Windows). On Mac, Shift + Cmd + =.
  • Ctrl + Alt + F9 – Forces a full recalculation, even of cells that Excel thinks don’t need it (Windows only).

If you’re using Manual mode because a workbook is large and slow, you can press F9 after making changes to update results without switching modes.

Fixing Text-Formatted Cells

If a formula displays as text (e.g., you see =A1+B1 instead of a number), the cell is likely formatted as Text. This happens when you apply Text formatting before typing the formula, or when you import data from a text file. To fix:

  1. Select the cell or range.
  2. On the Home tab, in the Number group, change the format from Text to General (or any numeric format).
  3. Click into the formula bar and press Enter to re-enter the formula.

Alternatively, select the range and use Data > Text to Columns, then click Finish without changing any options. This forces Excel to re-evaluate the cell contents.

Dealing with Circular References

A circular reference occurs when a formula refers to its own cell, either directly (e.g., =A1+1 in cell A1) or indirectly (e.g., A1 refers to B1, and B1 refers to A1). Excel shows a warning and may stop calculating automatically to avoid infinite loops. To find the circular reference:

  1. Go to Formulas > Error Checking > Circular References.
  2. The dropdown lists the cells involved. Click each one to jump to it.
  3. Review the formulas and adjust them so they don’t refer back to themselves.

If you intentionally need a circular reference (e.g., for iterative calculations), you can enable iterative calculation in File > Options > Formulas and set a maximum iterations value. But for most users, it’s best to remove the circular reference.

Volatile Functions and Recalculation

Volatile functions recalculate every time Excel recalculates, even if their inputs haven’t changed. This can slow down large workbooks, but it also means they should always be current. If a volatile function isn’t updating, check the calculation mode first. If it’s set to Automatic, but the function still doesn’t update, try pressing Ctrl + Alt + F9 to force a full recalculation. Note that RAND() and NOW() will generate new values each time, which is normal.

Other Common Culprits

  • Formulas hidden or not showing results – If you see the formula text instead of a value, check the Show Formulas mode (Ctrl + `). Toggle it off.
  • Excel thinks the cell is empty – If a cell contains a space or non-breaking character, Excel may not treat it as a number. Use =ISNUMBER(A1) to test.
  • Calculation precision – Excel’s default precision is 15 digits. If you need more, you can set File > Options > Advanced > Set precision as displayed, but this permanently changes stored values.
  • Add-ins interfering – Some add-ins can override calculation settings. Disable add-ins temporarily to test.

Frequently Asked Questions

Why is my Excel not calculating even after I press F9?

If F9 doesn’t update values, the formula might be in a cell formatted as text, or the workbook might have calculation set to Manual but the formula is also volatile and needs a full recalculation (try Ctrl+Alt+F9). Also check if the cell contains a formula at all – it might be a hardcoded value.

How do I make Excel calculate automatically on Mac?

On a Mac, go to the Formulas tab and click Calculation Options, then choose Automatic. The keyboard shortcut to recalculate is Cmd + = (or Fn + F9 if your keyboard uses function keys).

Why does Excel show the formula instead of the result?

This usually happens when the cell is formatted as Text, or when you accidentally enabled Show Formulas (Ctrl + `). Change the cell format to General and re-enter the formula, or press Ctrl + ` to toggle off.

Can I set automatic calculation for only one sheet?

No, calculation mode is a workbook-level setting. You cannot set it per sheet. However, you can use Shift + F9 to recalculate only the active sheet when in Manual mode.

What does ‘Calculate’ mean in the status bar?

If you see “Calculate” in the status bar, it means Excel has pending calculations that haven’t been performed, usually because calculation is set to Manual. Click it to recalculate, or switch to Automatic mode.

Will changing calculation mode affect other workbooks?

Yes, calculation mode is a global Excel setting, not per workbook. Changing it affects all open workbooks and future ones until you change it back.

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.