How to find a circular reference in Excel?
Braxorn · Last updated 2026-11-22 · English
A circular reference occurs if a formula depends on its result directly or through other cells. The simplest example is to include the total cell in its own summation range.
What can you do?
- Find the affected cell in the Error Checking and Circular References options in the Formulas section.
- Follow the references to determine at what point the calculation reverts to its own result.
- Correct the incorrect range or connection and recheck any other loop warnings.
A small example
The formula =SUM(B2:B10) in cell B10 It also collects B10. If the goal is to collect the data at the top, the ending address should be B9.
What to watch for
Do not turn on iterative calculation to silence the warning. Recursion is used deliberately in some specific models; It is not a suitable solution for the ordinary sum error.
Check the result
When you change an input, the result should change logically and the loop warning should not repeat.
Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.
Microsoft source (English)
Review your own workbook
You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.
Review your file