Circular Reference Error in Excel: How to Find It Fast

To find a circular reference in Excel for Microsoft 365 on Windows, select Formulas > Error Checking > Circular References, then click a listed cell address. Excel selects a cell involved in the loop; inspect its formula and trace the cells it depends on until you find the reference that leads back to itself. A circular reference occurs when a formula depends on its own result, directly or through other cells, and can prevent expected calculations.

Before changing formulas, save a copy of the workbook. If Excel lists more than one circular reference, work through them one at a time and repeat the check after each repair. Fixing one loop can reveal another.

What You’ll Need

Excel for Microsoft 365 desktop on Windows, with the workbook open and editable. The steps also apply to many recent desktop versions of Excel.
A saved copy of the workbook, especially if it contains important formulas or linked worksheets.
Access to all relevant sheets, including hidden sheets if you are permitted to unhide them. A loop can involve cells on different worksheets.

Step-by-Step

Save a working copy and note the warning. Use File > Save As to make a separate copy before editing. If Excel displayed a circular-reference warning when you opened the workbook or entered a formula, note the sheet and cell mentioned. The warning may identify only a starting point, not every cell in the loop. If the message has already disappeared, continue with the menu check below.
Check the status bar for a circular reference. Look along the bottom edge of the Excel window. When Excel detects a circular reference, the status bar may show the words Circular References and a cell address. Click the address if it is available to select that cell. The status bar is a useful clue, but do not assume that one address is the only problem in the workbook.
Open Excel’s circular-reference list. On the ribbon, select Formulas > Error Checking > Circular References. If the menu lists a cell address, click it. Excel moves to that cell, which is part of a circular reference. Record the sheet name and address so you can return to it. If the Circular References item is unavailable or no address appears, confirm that calculation is not being handled as an intentional iterative model, then follow the troubleshooting section.
Read the selected cell’s formula and identify its inputs. Select the cell and inspect the formula bar above the worksheet. Check whether the formula refers to the cell containing the formula itself. For example, a formula in D8 that includes D8 as one of its inputs is a direct circular reference. Also check ranges: a formula in a total cell can accidentally include its own row or column. Use the cell references and sheet names in the formula to locate each input rather than changing the first formula you see.
Trace references when the loop is indirect. A formula can be circular even when it does not mention its own cell. For example, a formula in D8 might use E8, while E8 depends on F8 and F8 refers back to D8. Select the suspected cell, then use Formulas > Trace Precedents to show cells feeding into it. Follow the arrows and inspect the formulas in the connected cells. Use Formulas > Trace Dependents to see which cells rely on the selected cell. The arrows help map the chain; they may not make a complex loop obvious in one view. Select another cell in the chain and trace again. Use Formulas > Remove Arrows when you want to clear the displayed arrows.
Check other sheets, names, and hidden areas. If the formula refers to another worksheet, open that sheet and inspect the referenced cell. A loop can cross several worksheets. If the references are hard to follow, open Formulas > Name Manager and review names used by the formula; a defined name can point to a range that leads back to the original cell. Also look at hidden worksheets if you are authorized to view them. Do not unhide or alter protected content without checking with the workbook owner.
Repair the cause, then check again. Decide what the calculation is meant to do. Remove the self-reference, correct an incorrect range, or adjust the upstream formula so the dependency chain no longer returns to the starting cell. If the formula is meant to calculate a total, ensure the total cell is not included among its own inputs. Recalculate the workbook with Formulas > Calculate Now, then reopen Formulas > Error Checking > Circular References. Continue until Excel no longer lists an unintended loop, and verify that the repaired values make sense.

These ribbon labels are for Excel desktop on Windows. In Excel for Mac, the Formulas tab includes formula-auditing tools, but menu placement and shortcut keys can differ by release. On Mac, use Command+F instead of Ctrl+F for Find. Excel for the web can display workbook errors, but its auditing and navigation options may be more limited; open the file in desktop Excel if you cannot access the circular-reference list or trace arrows.

Common Mistakes

Changing the first highlighted formula without tracing it. The selected cell is part of the loop, but it may not be the cell where the mistake was introduced. Follow the dependencies and compare them with the intended calculation before editing.
Assuming the error must be on the active worksheet. A formula can point to another sheet, and that sheet can lead back to the original. Check the sheet name in each reference and follow the chain across tabs.
Fixing one loop and stopping. Excel may report another circular reference after the first is removed. Recheck the menu after every repair, especially in large workbooks with copied formulas.
Turning on iterative calculation just to hide the warning. Iterative calculation allows Excel to recalculate circular formulas repeatedly under set limits. It is appropriate only when the workbook is deliberately designed for that method. Enabling it does not correct an accidental reference and can make incorrect results appear plausible.
Overlooking a total range or copied formula. A formula copied down a column may shift its references unexpectedly. A total that includes its own cell is a frequent cause. Check the exact range boundaries and compare the formula with neighboring rows.

Tips

Keep a simple dependency map. Write down the starting cell and each cell it relies on, including sheet names. For example, note that Summary!D8 depends on Detail!E8, then record what E8 depends on. This makes a multi-sheet loop easier to review and reduces repeated clicking.
Use the formula bar as well as arrows. Arrows are visual aids, not a substitute for reading each formula. Long formulas, named ranges, and references to other sheets can make the arrow display crowded or incomplete for your purposes.
Compare neighboring formulas. If the circular reference appeared after filling a formula down or across, compare the selected formula with the cells beside it. Look for a range that includes the current row, an unexpected sheet reference, or a relative reference that shifted.
Make one change at a time. After each repair, recalculate and check the circular-reference list again. This makes it easier to identify which edit removed the loop and to reverse an unintended change.
Use iterative calculation only with a defined reason. If the workbook intentionally uses circular calculations, ask its owner for the expected iteration settings and acceptable results. On Windows, those settings are under File > Options > Formulas. Do not change them simply to silence an error message.

Troubleshooting

The Circular References menu is empty or unavailable. Confirm that the workbook is open in desktop Excel and that you are looking at the workbook that produced the warning. If iterative calculation is enabled, the workbook may be using circular formulas intentionally, so inspect the calculation settings and ask the workbook owner whether the loop is expected. If you suspect an accidental loop, save a copy and review the formulas around the cells that were recently edited.

Excel selects a cell, but you cannot see the full loop. Read the formula bar, identify each referenced cell, and select those cells one by one. Repeat Trace Precedents as needed, including on other sheets. Check Name Manager for defined names that conceal part of the reference path. A formula can also use a range, so inspect every cell in a relevant range rather than following only one visible arrow.

The warning returns after you fix a formula. There may be a second loop, or the edited formula may still lead back to itself through another cell. Run the circular-reference check again and trace the newly listed cell. If the workbook uses macros or external links that change formulas, check whether those actions recreate the reference after you repair it.

The workbook calculates but the result looks wrong. A displayed value is not proof that the circular reference is harmless. Check whether iterative calculation is enabled and review the workbook’s intended calculation logic. If the loop is intentional, confirm the maximum iterations and maximum change settings with the workbook owner. If it is not intentional, disable the unintended dependency rather than relying on an approximate result.

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 its own cell, or indirect, through one or more other cells or worksheets.

Can Excel find every circular reference at once?
The Circular References menu helps locate detected cells, but you should not assume the first listed address represents every loop. Repair one, recalculate, and check the menu again to find any remaining references.

Why does Excel not show the circular-reference warning?
The warning may have appeared earlier, the workbook may have iterative calculation enabled, or you may be viewing a different workbook. Check Formulas > Error Checking > Circular References and review the calculation settings before concluding there is no loop.

Should I enable iterative calculation?
Only if the workbook is intentionally built to use circular calculations and you know the expected settings. For an accidental circular reference, find and repair the dependency instead; iteration can mask the cause rather than fix it.

Can a circular reference involve more than one worksheet?
Yes. A formula on one sheet can depend on a cell on another sheet, whose formula eventually points back to the first. Follow sheet-qualified references and inspect each cell in the chain.

Do these steps work in Excel for the web?
Some formula checks are available in the web version, but navigation and auditing features can differ. For the clearest route to the circular-reference list and trace arrows, open the workbook in Excel desktop.

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.