Circular References in Excel: How to Find and Fix Them

To find a circular reference in Excel for Microsoft 365 on Windows, select Formulas > Error Checking > Circular References, then click a cell listed in the menu. Excel jumps to that cell so you can inspect its formula. A circular reference occurs when a formula depends on its own result, either directly or through other cells. Save a copy of the workbook first if you plan to change calculation settings or edit complex formulas.

What You’ll Need

The workbook that shows the circular-reference warning, ideally opened in the Excel desktop app.
Permission to edit the workbook if you need to change formulas or calculation settings.
A few minutes to check related cells. The first cell Excel identifies may be only one part of a longer chain.

Step-by-Step

Open the workbook in desktop Excel. If the file is in OneDrive or SharePoint, open it in the Windows desktop app for the clearest access to formula-auditing tools. If Excel displays a warning when the workbook opens, note it, but you do not have to resolve the reference immediately. Avoid turning on iterative calculation just to dismiss the warning; that setting can change how formulas calculate.
Open the Circular References list. On the ribbon, select Formulas > Error Checking and open the Circular References submenu. Excel lists the cell or cells it has identified. If the submenu is unavailable or shows no address, continue with the checks below; calculation settings, workbook state, or a reference on another sheet can make the source less obvious.
Select a listed cell address. Click the address in the submenu. Excel moves to that cell, selecting it on the relevant worksheet. Look at the formula bar to read the full formula, especially if the cell is narrow or the formula is too long to see in the grid. Write down the sheet name and cell address before editing so you can return to it.
Check whether the formula refers to itself directly. A direct circular reference is a formula in a cell that includes that same cell in its calculation. For instance, a formula in D8 that uses D8 as one of its inputs depends on its own result. Check both individual cell references and ranges: a range that includes the formula cell can create the loop even when the cell address is not obvious at first glance. If you find a self-reference, decide whether it is accidental or intentionally part of an iterative model before changing it.
Trace the chain when the cell does not refer to itself. The loop may travel through several cells or sheets. Select the identified cell, then choose Formulas > Trace Precedents to show cells feeding into its formula. Follow those references and inspect their formulas. You can also use Formulas > Trace Dependents to see cells that rely on the selected cell. Repeat the checks until you find a path that returns to the starting cell. Select Remove Arrows in the Formula Auditing group when you are finished tracing.
Check other worksheets and named ranges. A formula on one sheet can depend on a cell on another sheet, which in turn points back to the first sheet. Follow sheet-qualified references in the formula bar and inspect the referenced cells. If the formula uses a name instead of a visible address, open Formulas > Name Manager and inspect the name’s Refers to entry. A name that points back to the formula cell or to a range containing it can complete the loop.
Correct the logic, then check the list again. If the loop is unintended, change the formula or reference so the calculation follows the intended direction. For example, keep an input separate from a calculated output rather than having the output include itself in its source range. Return to Formulas > Error Checking > Circular References. If another address appears, investigate it too; fixing one loop can reveal a separate one. Save the workbook, recalculate, and confirm the warning no longer appears.

Common Mistakes

Changing the first formula you find without following its dependencies. Excel’s listed cell is a useful starting point, but it may be one link in a multi-cell loop. If you replace that formula without understanding the chain, you can remove a needed calculation or leave another loop intact. Trace the precedents and identify the point where the references circle back.

Overlooking a range that includes its own cell. A total formula can accidentally include the cell containing the total, particularly when a range is expanded or copied. Check the beginning and end of every referenced range, not just the visible values beside the formula.

Assuming every circular reference is an error. Some financial, engineering, or other models intentionally use repeated calculations to approach a result. Those models may rely on Excel’s iterative calculation setting. Do not remove a deliberate loop until you understand the workbook’s design, and do not enable iteration as a quick fix for an unexplained warning.

Ignoring other sheets or defined names. The return path can be hidden in a different worksheet or in a named range. A formula that looks harmless when viewed alone can still participate in a circular chain.

Tips

Make a copy before substantial troubleshooting, particularly when a workbook contains linked sheets, macros, or shared calculations. Give the copy a clear name and use it to test formula edits. This makes it easier to compare the original calculation with your changes and restore the workbook if an edit has unintended effects.

Use the formula bar rather than relying only on what appears in the cell. It shows the full formula, including references that may be hidden by column width. When tracing across sheets, note each address in order, such as the starting cell, its precedent, and the next precedent. That short map makes it easier to see where the route returns to the start.

If the workbook is large, check the Circular References submenu again after each correction rather than trying to repair many cells at once. Resolve one reported loop, recalculate, and then investigate the next address. This keeps each change focused and helps you distinguish a new issue from another link in the original loop.

Excel for Mac has similar auditing tools, although the ribbon layout and settings labels can differ by release. Look on the Formulas tab for Error Checking and Circular References, then use the formula-auditing commands to trace dependencies. In Excel for the web, some desktop auditing options may be limited or arranged differently. If you cannot find the list or trace arrows, choose Open in Desktop App and continue there.

Troubleshooting

The Circular References submenu is empty, but Excel still reports a problem. Confirm that you are looking at the workbook that produced the warning and that it has finished calculating. Check whether iterative calculation is enabled under File > Options > Formulas on Windows. If it is enabled, the workbook may be set to allow circular calculations rather than stop at the usual warning. Before changing this setting, save a copy and note the original option so you can restore it. If you disable iteration temporarily, recalculate and inspect the warning, then restore the setting if the model needs it.

The listed cell looks normal. Inspect its full formula and follow every referenced cell, including references on other sheets. Check defined names in Name Manager, and look for ranges that include the selected cell. A formula can also reach itself through a long chain, so the loop may not be visible in the first cell’s formula.

Excel keeps showing another address after you fix one. There may be more than one circular reference, or fixing the first may have allowed Excel to identify the next one. Repeat the process for each listed address. Do not assume the workbook is clear until the menu and any warning indicate that no circular reference remains.

You cannot find the referenced cell or arrows stay on screen. Check the sheet tab name shown in Excel and use Formulas > Remove Arrows to clear tracing markers. If a reference points to a hidden worksheet, unhide it if you have permission, or ask the workbook owner to help inspect it. In a protected workbook, you may be able to view formulas but not edit them; request access rather than working around the protection.

You are working in Excel for the web. Open the workbook in desktop Excel if the relevant Error Checking or Formula Auditing commands are missing. The web app’s features can vary, so avoid relying on an option that is not visible in your version. After locating the issue in the desktop app, save the workbook and reopen it in the browser if you need to continue collaborating there.

Frequently Asked Questions

What is a circular reference in Excel?
A circular reference is a calculation loop: a formula refers to its own result directly or through one or more other cells. Excel cannot calculate a normal one-way result from that loop unless iterative calculation is deliberately used.

Can Excel show exactly where the circular reference is?
Usually, yes. On Windows, use Formulas > Error Checking > Circular References and select a listed address. Treat it as a starting point, because the full loop may include additional cells or worksheets.

Why does Excel show only one circular-reference cell?
Excel may identify one part of a loop first, and additional references can become apparent after you correct it. Check the menu again after each repair and trace dependencies instead of assuming the first address is the whole problem.

Will enabling iterative calculation fix the circular reference?
It allows Excel to recalculate certain intentional loops repeatedly, but it does not correct an accidental formula. Only enable it when the workbook is designed for iterative calculations and you understand the calculation limits and expected result.

Can I locate circular references in Excel for Mac?
Yes. Look for Formulas > Error Checking > Circular References and the Formula Auditing tools. Labels or ribbon placement can vary by Mac release; if a command is not available, inspect the formulas and use desktop Excel’s auditing options where possible.

Can I find a circular reference in Excel for the web?
Some warning or checking behavior may be available, but the web app does not always expose the same auditing controls as desktop Excel. Open the workbook in the desktop app if you need the Circular References list or trace arrows.

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.