Excel circular reference warning: find and fix it

What a circular reference is, how to find the cell causing it, and how to remove it.

The message you see
There are one or more circular references
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Check a workbook that won't behave →

Why this happens

How to fix it

  1. 1Go to Formulas → Error Checking → Circular References to jump to the cell.
  2. 2Change the range so it ends above the formula cell.
  3. 3Only enable iterative calculation if you intentionally need it.

Related guides

Still stuck? Ask SheetFix Support