Check Circular References in Excel: Find and Fix Them

To check for a circular reference in Excel for Microsoft 365 on Windows, open the Formulas tab, select Error Checking, then point to Circular References. Choose a listed cell to go to it, inspect its formula, and change the formula or its references so the calculation no longer leads back to itself. Excel can also show a circular-reference warning when you enter a formula.

A circular reference occurs when a formula refers to its own cell, either directly or through other formulas. It can stop a calculation from producing the intended result, but some financial and engineering models deliberately use iterative calculations. Before changing anything, decide whether the circularity is accidental or part of a model that is meant to iterate.

What You’ll Need

A copy of the workbook in desktop Excel, preferably saved before you edit formulas.
Permission to edit the affected cells. If the sheet is protected, you may need the password or help from the workbook owner.
A basic understanding of what the affected calculation is supposed to return. This makes it easier to distinguish a genuine error from an intentional iterative model.

Step-by-Step

Save a working copy. Use File > Save As and save a separate copy before changing formulas, especially in a shared or business-critical workbook. A circular reference can be part of a complex chain, and overwriting a formula may affect totals or reports elsewhere.
Look for Excel’s warning. If you have just entered or edited a formula that creates a circular reference, Excel may display a warning explaining that it found one. Note the cell address shown in the message. If you choose to continue, Excel may keep the formula and show a result based on its calculation settings; continuing does not mean the formula is correct. If you have not yet entered the formula, cancel the edit and check the cell references first.
Check the status bar. Look along the bottom of the Excel window for a circular-reference notice. If it appears, note whether Excel shows a cell address. The status bar can help confirm that the workbook contains a circular reference, but it may not explain the full chain of cells involved.
Open the Circular References list. Select Formulas > Error Checking > Circular References. In the submenu, select a listed cell reference to move to that cell. If more than one reference is listed, inspect each one. The list is a starting point: a cell shown there may be part of a chain, and the formula that needs changing may be in another cell in that chain.
Inspect the formula and its inputs. Select the cell Excel took you to and read the formula bar. Check whether the formula includes its own cell address, or whether it refers to another cell that eventually points back to it. Also check named ranges, totals, and formulas on other worksheets. For example, a total placed inside the range it totals can refer to itself even if the formula does not visibly use the total cell’s address by name.
Trace the references if the loop is not obvious. Select a formula cell, then use Formulas > Trace Precedents to show cells that feed into it. Use Formulas > Trace Dependents to see cells that use its result. Follow the arrows and inspect the formulas along the path until you find where the chain returns to a cell already visited. Repeat from a listed circular-reference cell if needed. When finished, select Formulas > Remove Arrows to clear the tracing marks.
Correct the formula or structure. Common fixes include moving a total outside the range it totals, changing an incorrect cell reference, or splitting a long calculation into separate helper cells. Make the smallest change that matches the intended calculation. Then check that the cell shows the expected result and that dependent totals or charts still make sense.
Check the workbook again. Reopen Formulas > Error Checking > Circular References and review any remaining entries. Excel may expose another loop after the first one is corrected, so repeat the inspect-and-fix process. Save the workbook only after you have confirmed that any remaining circular references are intentional.

For example, suppose a worksheet has a column of expense amounts and a total cell at the bottom. If the total formula includes the total cell itself in the range, the total depends on its own value. The usual correction is to adjust the summed range so it includes only the expense entries. This is different from a deliberate iterative model, where formulas are designed to feed values back through a calculation.

Common Mistakes

Assuming the first listed cell is the only problem. A circular reference can involve several cells, or one loop can lead into another. Check the formulas connected to the listed address and revisit the menu after each correction.
Changing a formula without checking what it should calculate. Removing a reference at random may silence the warning but produce a wrong total. Confirm the intended inputs and result before editing.
Confusing iterative calculation with a fix. Turning on iteration can make Excel calculate some circular formulas repeatedly, but it does not repair a mistaken reference. Use it only when the model is intentionally circular and you understand its calculation rules.
Looking only at the active worksheet. A chain can pass through other sheets, named ranges, or cells hidden by filters. Check referenced sheets and names as well as the cell selected by Excel.
Ignoring a warning because a number appears. A displayed value does not prove that a circular formula is correct. The outcome may depend on workbook settings or the last calculated value.

Tips

Use a working copy and change one formula at a time. That makes it easier to identify which edit removed the loop and to restore the original if the result is wrong.
When a formula is long, break it into intermediate calculations in clearly labelled helper cells. Smaller formulas are easier to audit and make dependency paths easier to follow.
Use descriptive worksheet names and named ranges carefully. Names can make formulas easier to read, but an incorrect name definition can hide a route back to the formula cell.
After correcting a loop, verify more than the displayed value. Check relevant totals, dependent formulas, and a known example or expected result from the workbook owner.
If the workbook is meant to use circular calculations, document why iteration is needed and which cells participate. This helps someone reviewing the workbook avoid “fixing” an intentional model later.

Troubleshooting

The Circular References menu is unavailable or empty. First make sure you are in the desktop Excel app and that the workbook is open and calculating. Select a cell in the workbook, then check the status bar and try the Error Checking menu again. If the workbook was just opened or recalculated, wait for calculation to finish. In Excel for the web, circular-reference investigation tools may be more limited; open the file in desktop Excel for the full ribbon workflow.

Excel identifies a cell, but you cannot see the loop. The selected cell may be only one point in a longer chain. Use Trace Precedents and Trace Dependents, and follow references across worksheets. Check defined names in Formulas > Name Manager, since a formula can refer to a name whose definition points back to the formula cell. Also inspect formulas in hidden rows or columns if they are part of the calculation.

The warning returns after you edit a formula. The change may have moved rather than removed the circular dependency, or another circular reference may remain. Reopen the Circular References list and inspect the new entries. If you pasted a range or copied formulas, check that relative references shifted as intended and that a copied total did not become part of its own range.

You need a circular model to calculate. On Windows, go to File > Options > Formulas and, under Calculation options, select Enable iterative calculation. Excel provides settings for maximum iterations and maximum change; choose values appropriate to the model rather than relying on defaults without review. This setting applies to the workbook, so document the reason for enabling it and verify the model’s convergence and results. On Mac, calculation preferences are under Excel > Settings (or Preferences in some releases) > Calculation. The wording and location can vary by release.

Frequently Asked Questions

What is a circular reference in Excel?
A formula has a circular reference when its result depends on itself. The dependency can be direct, through the same cell, or indirect, through one or more other formulas.

Where does Excel show circular references?
On Windows desktop Excel, check the status bar and use Formulas > Error Checking > Circular References. Select a listed address to navigate to the corresponding cell.

Can a workbook have more than one circular reference?
Yes. It can contain multiple loops, and a single loop can involve several cells. Correcting one may reveal another, so check the menu again after each change.

Does enabling iterative calculation remove the circular reference?
No. It allows Excel to recalculate an intentional circular model repeatedly according to iteration settings. It does not remove a bad reference or guarantee that the result is correct.

Can I check circular references in Excel for the web?
You can open and edit many workbooks in Excel for the web, but its tools for tracing and diagnosing circular references may be limited compared with desktop Excel. For the steps in this guide, open the workbook in Excel for Microsoft 365 on Windows.

Why does Excel show a circular-reference warning after I fixed one?
There may be another loop, or the revised formula may still connect back to itself through other cells. Review the updated Circular References list and trace the dependencies again.

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.