In Excel: a formula refers directly or indirectly to its own cell, creating a loop Excel cannot resolve — locate it via Formulas ▸ Error Checking ▸ Circular References and break the loop by restructuring the formula.
On this page8
Fix:Circular Reference
What causes Circular Reference
A circular reference occurs when a formula in cell X includes cell X in its own calculation — either directly (=A1+A1 entered in A1) or indirectly through a chain (A1 refers to B1 which refers to C1 which refers back to A1). Excel cannot compute an infinite loop, so it either shows 0 (when iterative calculation is off, the default) or it keeps iterating until a maximum number of loops is reached (when iterative calculation is on). The status bar at the bottom of Excel shows "Circular References: [cell address]" when one exists. Circular references are almost always unintentional — a formula accidentally reaching back to include its own cell is the most common cause.
How to fix Circular Reference
- Go to Formulas ▸ Error Checking ▸ Circular References — Excel lists the cell(s) involved in the circular reference chain.
- Click the cell address in the Circular References list to jump directly to it.
- Read the formula in that cell and identify which part references the cell itself (directly or via a chain through other cells).
- Move the formula to a different cell that is not in its own reference range — this is the most common fix.
- If the reference chain is indirect (A→B→C→A), use Formulas ▸ Trace Precedents on each cell in the chain to map the loop.
- If iterative calculation is intentional (e.g. for a running balance), enable it under File ▸ Options ▸ Formulas ▸ Enable Iterative Calculation, and set a Maximum Iterations and Maximum Change value — but document this clearly as it makes the model harder to audit.
Go to Formulas ▸ Error Checking ▸ Circular References — Excel lists the cell(s) involved in the circular reference chain.
Click the cell address in the Circular References list to jump directly to it.
Read the formula in that cell and identify which part references the cell itself (directly or via a chain through other cells).
Move the formula to a different cell that is not in its own reference range — this is the most common fix.
If the reference chain is indirect (A→B→C→A), use Formulas ▸ Trace Precedents on each cell in the chain to map the loop.
If iterative calculation is intentional (e.g. for a running balance), enable it under File ▸ Options ▸ Formulas ▸ Enable Iterative Calculation, and set a Maximum Iterations and Maximum Change value — but document this clearly as it makes the model harder to audit.
What this does
A circular reference occurs when a formula in cell X includes cell X in its own calculation — either directly (=A1+A1 entered in A1) or indirectly through a chain (A1 refers to B1 which refers to C1 which refers back to A1). Excel cannot compute an infinite loop, so it either shows 0 (when iterative calculation is off, the default) or it keeps iterating until a maximum number of loops is reached (when iterative calculation is on). The status bar at the bottom of Excel shows "Circular References: [cell address]" when one exists. Circular references are almost always unintentional — a formula accidentally reaching back to include its own cell is the most common cause. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. Treat “find circular references in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a data step that keeps your analysis trustworthy into a method you can reuse, explain, and defend when the workbook leaves your screen.
A worked example
Scenario: you enter =SUM(A1:A10) in cell A5, which is inside the range A1:A10. The formula is trying to include its own result in the sum — an endless loop. Excel shows 0 in A5 and the status bar says "Circular References: A5." To fix: move the formula to a cell outside the range (e.g. A11) or change the range to A1:A4, A6:A10. A subtler case: =IF(B1="done", A1, A1+1) in A1 — A1 always refers to itself. Fix by restructuring: put the counter in a helper cell that A1 does not reference. Treat a circular reference warning as an urgent bug, not a cosmetic issue. In the default (non-iterative) mode, every cell in the chain returns 0, silently corrupting every aggregate formula that depends on those cells. Because Excel continues to show 0 rather than a visible error, the corruption can persist undetected across many dependent sheets before anyone notices the numbers are wrong. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. The short version of “find circular references in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
Common mistakes
- Accidentally selecting "the entire column" in a
SUMrange when theSUMformula itself is in that column —=SUM(A:A)entered in any cell in column A creates an immediate circular reference. - Enabling iterative calculation to "fix" a circular reference without understanding the chain — iterative calculation converges to a number, but that number may be meaningless if the loop is accidental rather than intentional.
- Copying a formula from one cell to a range that includes the source cell — Excel shifts relative references during the copy, which can accidentally create new circular references in the copied cells.
Frequently asked questions
How do I find a circular reference in a large workbook?
Go to Formulas ▸ Error Checking ▸ Circular References. Excel lists every cell that is part of a circular loop. If the list is empty but the status bar still says "Circular References," check every sheet — the circular reference may be on a different sheet than the one currently visible.
Why does Excel show 0 instead of an error for a circular reference?
When iterative calculation is off (the default), Excel cannot evaluate the circular loop so it returns 0 and displays a warning in the status bar. When iterative calculation is on, Excel evaluates the formula the specified number of times and displays the last computed value. Neither is "correct" — you should break the loop.
Are circular references ever intentional and correct?
Rarely — some financial models use them intentionally for running totals, interest-on-interest calculations, or target-seeking scenarios where iterative convergence is desired. In those cases, enable iterative calculation consciously and document the reason. For the vast majority of users, a circular reference is a mistake that should be resolved by restructuring the formula.
Other ways people ask this
People reach this page typing “excel finding circular references”, “how do you find circular references in excel”, “excel found a problem with formula references” and “find circular references in excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “excel finding circular references”, “how do you find circular references in excel”, “excel found a problem with formula references” all point at the one operation explained on this page, which is why they all lead here.