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 referencesFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- A formula includes its own cell, e.g. =SUM(A1:A10) in A10.
- Two formulas refer to each other indirectly.
How to fix it
- 1Go to Formulas → Error Checking → Circular References to jump to the cell.
- 2Change the range so it ends above the formula cell.
- 3Only enable iterative calculation if you intentionally need it.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support