Excel troubleshooting

How to Fix a Circular Reference in Excel

Resolve Excel circular reference warnings when a formula directly or indirectly refers back to its own cell.

Problem

  • Excel shows a circular reference warning when a formula depends on its own result, directly or through a chain of other formulas.

Quick fix

  • Use Formulas > Error Checking > Circular References to locate the cell, then break the loop with a separate input cell or iterative calculation only when intentional.

Typical causes

  • A formula in A1 refers to A1, even accidentally through a range like A1:A10.
  • Two cells refer to each other, creating an indirect loop.
  • A named range includes the cell that uses the name.

Best fixes

  • Move the input assumption to a separate cell and reference it from the formula.
  • Use Formulas > Error Checking > Circular References to jump to the problem cell.
  • Enable iterative calculation only for intentional financial or modeling loops.

Frequently asked questions

  • Are circular references ever intentional? Rarely in financial models (iterative calculation). For most users, circular refs are accidental and should be removed.
  • How do I find the circular cell? Formulas → Error Checking → Circular References lists the chain. Fix the first cell in the loop.
  • Named range caused circular reference? Ensure the named range does not include the cell that uses the name in its formula.