Microsoft Excel — "Circular Reference" Warning — What It Means & How to Fix It

What Does This Error Mean?

A circular reference means one of your formulas is referring back to itself — either directly or through a chain of other cells. For example, if cell A1 contains a formula that uses A1 as part of its calculation, that is a circular reference. Excel cannot calculate this because it creates an endless loop — like asking 'what is the answer that depends on the answer?'

Affected Models

Microsoft Excel 2016
Microsoft Excel 2019
Microsoft Excel 2021
Microsoft 365 Excel

Common Causes

A formula directly references the cell it lives in (for example, =A1+B1 typed into cell A1)
A chain of formulas loops back on itself across multiple cells
A SUM formula accidentally includes the cell it is in within its range
Copy and paste moved a formula into a cell that is referenced by that formula
Iterative calculation features are being used unintentionally

How to Fix It

Look at the bottom-left status bar in Excel. It will say 'Circular References:' followed by a cell address — for example, 'Circular References: B5'. Click that cell first to investigate.

Excel identifies the cell where it detected the circular reference. This is your starting point.
Go to Formulas > Error Checking > Circular References. Excel will show you a list of all cells involved in circular references. Click each one to jump to it.

If the circular reference spans multiple cells, this menu shows the full list of all affected cells.
Click the cell with the circular reference and look at the formula bar. Check whether the formula references its own cell. If it does, edit the formula to reference a different cell.

The most common mistake is a SUM range that accidentally includes the SUM cell itself. For example, =SUM(A1:A10) typed into cell A10.
Use the Formula Auditing tools to trace the problem. Go to Formulas > Trace Precedents and Trace Dependents. Arrows will appear on the spreadsheet showing which cells feed into which.

For complex circular reference chains spread across many cells, the visual arrows make it much easier to follow the logic.
If you need the circular reference for a specific purpose (some financial models use them intentionally), enable iterative calculation. Go to File > Options > Formulas and check Enable iterative calculation.

Iterative calculation tells Excel to calculate circular references a set number of times (default 100 iterations). Only enable this if you are deliberately using circular references.

When to Call a Professional

Circular references are a formula logic problem, not a software failure. If you have a complex spreadsheet and cannot find the circular reference, a spreadsheet consultant or Excel-savvy colleague can trace the formula chain for you. For business-critical financial models, getting a second pair of eyes on the formulas is always worthwhile.

Frequently Asked Questions

Will a circular reference break my spreadsheet or corrupt my data?

It will not corrupt your data, but it will give you wrong answers. Excel either stops calculating (showing 0) or keeps recalculating in a loop depending on your settings. Either way, any cell that depends on the circular reference will show an incorrect value. Fix it as soon as you find it.

The circular reference warning appeared after I pasted some cells. Why?

When you paste a formula, Excel adjusts the cell references based on where you pasted it. Sometimes this adjustment lands the formula in a cell it is now referencing — creating an accidental circular loop. Press Ctrl + Z to undo the paste, then manually type the formula in the correct cell instead.

I fixed the circular reference but Excel still shows the warning. What do I do?

Close and reopen the spreadsheet — sometimes Excel does not clear the warning until a fresh recalculation. Alternatively, press Ctrl + Alt + F9 to force a full recalculation. Also check the Formulas > Error Checking > Circular References menu again — there may be a second circular reference elsewhere in the spreadsheet.