Excel Circular Reference: Find the Cell and Fix It

In Excel for Microsoft 365 on Windows, choose Formulas > Error Checking > Circular References, then click the listed cell to jump to it. If you cannot see the address there, check the status bar and trace the formulas: a circular reference can involve several cells or worksheets.

Find a circular reference from the ribbon

Start with Excel’s built-in error check. Open the workbook, select the Formulas tab, and use the command path below:

Choose Formulas > Error Checking.
Point to or open Circular References in the menu.
Click a cell address shown in the submenu. Excel takes you to that cell, where you can inspect its formula in the formula bar.

The command is useful because it points to a cell involved in the loop rather than merely describing the problem. It may not explain the entire chain, though. The selected cell might depend on another cell that eventually refers back to it, so inspect the surrounding formulas before changing anything.

Excel may also display a circular-reference warning when you enter a formula that creates a loop. If you dismiss the warning or open a workbook that already contains one, the ribbon command and status bar are useful places to look. The exact warning behavior can vary if iterative calculation is enabled.

What a circular reference means

A formula has a circular reference when its calculation depends, directly or indirectly, on its own result. In a direct example, suppose cell A1 contains the formula =A1+1. Because A1 needs its own value before it can calculate, the formula creates a loop. Under ordinary calculation settings, Excel cannot produce a dependable result for that formula.

A circular reference does not have to point back to the same cell immediately. Suppose A1 contains =B1+2, while B1 contains =A1/2. With A1 and B1 holding those formulas, calculating A1 requires B1, and calculating B1 requires A1. The cycle is A1 → B1 → A1, even though neither formula refers to its own cell directly.

This is different from a normal chain of dependencies. If A1 uses B1 and B1 uses C1, but C1 does not depend on A1 or B1, the chain has a starting point and Excel can calculate it. The key question is whether following the references eventually brings you back to a cell already in the chain.

Read the address and inspect the formula

After selecting an address from the Circular References menu, look at the Name Box to confirm which cell is active and read the formula bar to see the formula stored there. The cell address identifies a starting point for investigation, not necessarily the only cell that needs correction.

Check both the formula’s references and the cells those references lead to. For example, a formula may look reasonable on its own but be part of a loop because another cell includes it in a total, balance, or intermediate calculation. Follow the chain until you find the reference that closes the loop.

Excel’s status bar may show “Circular References” and a cell address. If the circular reference is on another worksheet, the status bar may identify the problem without giving you a directly useful address. In that case, use the ribbon’s Circular References list and inspect relevant sheets. The status bar is a clue, not a complete map of every dependency.

Trace the formula chain

Excel’s auditing arrows can help you see which cells feed a formula and which cells rely on it. Select a cell, then use Formulas > Trace Precedents to show cells that contribute to its value. Use Formulas > Trace Dependents to show cells whose formulas use the selected cell.

For a suspected cycle, begin at the address Excel identifies and trace its precedents. Follow the arrows and inspect each formula until you either reach cells with fixed values or return to a cell already visited. You can repeat the command on cells along the chain. Choose Formulas > Remove Arrows when the audit lines are no longer useful.

Arrows are most helpful when the dependencies are straightforward and visible on the worksheet. References across sheets can take more navigation, and complex formulas may contain several references at once. In those cases, read the formula bar, use the sheet tabs to inspect referenced cells, and keep a short written chain such as “Summary!B4 depends on Detail!F12; Detail!F12 depends on Summary!B4.” That makes the return path easier to spot.

Common causes and a practical example

A frequent mistake is including a total cell inside the range that it is supposed to total. Suppose A1:A9 contain the numbers 1 through 9, and A10 is intended to add them. If A10 contains =SUM(A1:A10), its range includes A10 itself. That creates a direct circular reference. In this layout, the corrected formula in A10 is =SUM(A1:A9); it returns 45 because 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 equals 45.

Other common causes include copying a formula into a cell that it references, using a balance formula that accidentally includes its own output, and creating a loop between summary and detail sheets. A formula copied across rows or columns can also shift its references in an unexpected way. When a circular reference appears after filling a formula, compare the cell’s references with those in a neighboring row or column.

Look closely at range boundaries, especially when inserting rows or changing a report layout. A range that used to end above a total may expand to include the total cell. Named ranges and formulas on hidden worksheets can also obscure the dependency path, so check names and workbook structure if the visible cells do not explain the loop.

Fix the loop without hiding the problem

Before editing formulas, decide what each cell is supposed to calculate. A quick change that removes an error message can still leave the workbook mathematically wrong. For a simple range mistake, correct the range so it excludes the result cell. For a more involved cycle, split the calculation into separate input, intermediate, and output cells so that the dependency direction is clear.

Remove an accidental self-reference. Check whether a formula includes its own cell in a range or refers to itself directly.
Break an unintended dependency loop. Decide which cell should be the input or source value, then revise the formula chain so calculations flow one way.
Check copied formulas. Confirm relative references shifted as intended and that absolute references, marked with dollar signs, point to the right cells.
Recheck the workbook. After a change, open Formulas > Error Checking > Circular References again. Inspect any remaining addresses and verify the resulting numbers against a simple independent calculation.

Do not assume that a cell is harmless just because it currently displays a number. With iterative calculation on, a circular formula can display a value produced through repeated calculation. That value may depend on settings and may not represent the intended model.

When iterative calculation is intentional

Some financial, engineering, or planning models deliberately use circular formulas to represent a calculation that converges through repeated updates. In such a model, Excel can recalculate the loop repeatedly until it reaches a set iteration limit or the change between results falls below a chosen threshold. This is called iterative calculation.

On Windows, the setting is under File > Options > Formulas. Select Enable iterative calculation, then review Maximum Iterations and Maximum Change. These settings affect whether Excel keeps recalculating a loop and when it stops. They do not repair an accidental reference or prove that the final value is meaningful.

Enable iteration only when the workbook’s design calls for it and you understand the expected result and stopping criteria. If a workbook unexpectedly begins showing circular-reference warnings, enabling iteration just to remove the warning can conceal a formula error. On Mac, Excel’s preferences and dialog labels differ by version; look in Excel settings or preferences for calculation options. Excel for the web has fewer auditing and settings controls than the desktop app, so use desktop Excel when you need to inspect or configure a complicated circular model.

Why the menu may not show what you expect

If the menu appears empty, first confirm that you have opened the workbook in the desktop version and that you are checking the right workbook. A circular reference may be on a different worksheet, including one that is hidden. Also check whether iterative calculation is enabled: a deliberately iterative workbook may behave differently from one using ordinary calculation.

If Excel lists a cell but the formula looks ordinary, follow its precedents rather than stopping at that cell. A single listed address does not mean the formula contains an obvious self-reference. Conversely, finding one cycle does not prove that every other formula is correct; after fixing it, check again and validate important outputs.

On Mac, use the Formulas tab and its error-checking or circular-reference controls where available; names and placement can vary between releases. If you cannot find the same command or need the clearest dependency view, open the file in Excel for Microsoft 365 on Windows. Avoid editing a shared or important workbook until you understand whether the circular formula is an intentional part of its model.

Frequently Asked Questions

How do I find a circular reference in Excel?
On Windows desktop Excel, choose Formulas > Error Checking > Circular References and click a listed address. Then inspect the formula and follow its precedents to see how the cycle closes.

Why does Excel say Circular References but show no cell address?
The loop may involve another worksheet, or the available status-bar message may not identify the location clearly. Use the Circular References command on the Formulas tab, then inspect formulas on the sheets involved.

Can a circular reference involve two or more cells?
Yes. If A1 depends on B1 and B1 depends on A1, the loop is indirect. Longer chains can span multiple cells and worksheets before returning to the starting cell.

Should I turn on iterative calculation to fix the warning?
Not unless the workbook is intentionally designed to calculate a circular model. For an accidental loop, correct the formula chain instead; iteration can make an unintended error harder to notice.

How can I remove a circular reference?
Identify the formula that closes the loop and revise the range or dependency so it no longer refers back to itself. Then check the Circular References menu again and verify that the corrected result makes sense.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.