Excel troubleshooting

Why Is My Excel Formula Not Calculating?

Fix Excel formulas that show the formula text, return zero, or never update because of manual calculation, text formatting, or blocked references.

Problem

  • Excel formulas fail to calculate when the workbook is in manual calculation mode, cells are formatted as text, or references point to invalid ranges.

Quick fix

  • Press F9 or switch to Automatic calculation, re-enter the formula in General format, and confirm the referenced ranges still exist.

Most common causes

  • Calculation mode is set to Manual instead of Automatic.
  • The cell is formatted as Text, so Excel stores the formula as plain text.
  • A referenced range was deleted, moved, or blocked by merged cells.

Reliable fixes

  • Go to Formulas > Calculation Options > Automatic.
  • Select the cell, set format to General, press F2, then Enter.
  • Use Evaluate Formula to inspect each argument step by step.

Frequently asked questions

  • Manual vs Automatic calculation? Switch to Automatic under Formulas → Calculation Options, or press F9 once in Manual mode.
  • Why does F9 fix it temporarily? F9 forces recalculation. If the workbook is Manual, every edit needs F9 or Automatic mode.
  • Circular reference stopping calc? Use Error Checking → Circular References to locate the loop before other fixes.