How to Find a Circular Reference in Excel Step by Step

In Excel for Microsoft 365 on Windows, select Formulas > Error Checking ▼, point to Circular References, then click a listed cell to go to it. Inspect the formula in that cell and follow its references until you find the loop. A circular reference occurs when a formula depends on its own result, either directly or through other cells.

What You’ll Need

The Excel workbook that contains the suspected circular reference, preferably opened in the desktop version of Excel for Microsoft 365 on Windows.
Permission to edit the workbook if you plan to correct a formula. If it is important or shared, make a copy before changing formulas.
A moment to check whether the circular calculation is intentional. Some financial and forecasting models use iterative calculation on purpose, so do not remove a loop until you understand what the workbook is meant to do.

Step-by-Step

Save a copy and identify the workbook. Before changing anything, use File > Save As to make a working copy, especially if the workbook is used by other people or contains important calculations. Confirm that the copy is the file you are inspecting. Circular references can involve formulas on different worksheets, so checking only the currently visible sheet may not be enough. If the workbook has several open windows, check its name in the Excel title bar.
Open Excel’s Circular References list. Select the Formulas tab, open the dropdown beside Error Checking in the Formula Auditing group, and point to Circular References. If Excel has detected a loop, a submenu displays one or more cell addresses. Click an address to move to that cell. If there is more than one listed address, note them down; Excel may require you to inspect and correct loops individually. The exact list can depend on which circular dependency Excel has currently detected.
Check the selected cell’s formula. With the listed cell selected, read the formula in the formula bar. A direct circular reference is easy to spot: for example, a formula in D8 that refers to D8 itself. A more common case is an indirect loop, where D8 refers to E8 and E8 eventually refers back to D8. References may also point to a different worksheet, so look at the sheet names in the formula as well as the cell addresses. Do not assume the selected cell is the only formula involved.
Follow the chain of references. For each cell used by the selected formula, go to that cell and inspect its formula. Continue until you find a reference that leads back to the starting cell or to another cell already in the chain. For a short chain, you can click each referenced cell or use the Name Box to go to an address. For a more complex formula, select the cell and use Formulas > Trace Precedents to show arrows to cells it depends on. Repeat on relevant cells. Use Formulas > Remove Arrows when the arrows become cluttered. Arrows can help reveal a route, but they do not always make a long, cross-sheet loop obvious at a glance.
Check whether the loop is intended. A circular reference is not automatically a mistake. Some models deliberately calculate a value repeatedly until it settles within a chosen limit. In desktop Excel for Windows, review File > Options > Formulas and look under Calculation options for Enable iterative calculation. If it is enabled, the workbook may be designed to allow circular formulas. Check the workbook instructions or ask its owner before disabling that setting or changing the formulas. Turning iteration off can change results in a model that relies on it.
Correct an accidental circular formula. Work out what the formula is supposed to calculate, then change the reference or move the calculation to a separate input cell. For example, a total formula should generally refer to the cells containing its component values, not to the total cell itself. If a range accidentally includes its own total cell, adjust the range. If two formulas refer to each other, decide which cell should hold the original input and update the other formula to use that input. Avoid replacing a formula with a typed value unless that is the intended design, because doing so removes the calculation.
Recheck the workbook after editing. Return to Formulas > Error Checking ▼ > Circular References and see whether Excel still lists a cell. If it does, click the address and inspect the remaining loop; there may be another circular reference or a second route through the same cells. Check any results that depended on the edited formulas and confirm they still make sense. Save the working copy when you are satisfied. If the list is empty, that is a useful sign, but also review the cells you changed and confirm the workbook calculates as intended.

Common Mistakes

Stopping after finding the first cell. Excel’s list takes you to a cell in the circular reference; it does not necessarily explain the whole dependency chain. A formula can look reasonable by itself and still lead back to its starting point through several other formulas. Follow the references until you can describe the entire loop.

Assuming every circular reference is accidental. Iterative models can use a circular dependency deliberately. Removing a formula or turning off iterative calculation without checking the workbook’s purpose can alter outputs throughout the file. Identify whether iteration is part of the model before making a correction.

Checking only one worksheet. One formula may refer to another sheet, whose formula then points back to the first sheet. A loop can also pass through named ranges. Inspect sheet names and, if the formula uses a defined name, look up that name in Formulas > Name Manager to see which cells it refers to.

Changing calculation settings as a first fix. Enabling iterative calculation can allow a circular formula to calculate, but it does not remove the dependency. It may hide an accidental loop or produce a result that depends on iteration settings. Use the setting only when the workbook is designed to use iterative calculations.

Fixing the wrong reference. A quick edit can remove the warning while also breaking the intended logic. Before changing a formula, identify the input cells, the expected output, and the role of the formula in the chain. Make one deliberate change at a time, then verify the results.

Tips

Write down the addresses in the loop as you trace them, such as D8 → E8 → F8 → D8. This makes it easier to explain the issue and see where the return path occurs.
Use Formulas > Evaluate Formula to step through a complicated formula one part at a time. It can clarify how Excel evaluates references, though it does not automatically map every cell in a dependency loop.
Keep raw inputs separate from calculated outputs. A dedicated input cell makes it less likely that a total or intermediate formula will include itself by mistake.
When formulas use large ranges, check the start and end addresses carefully. A total formula copied into a cell inside its own sum range is a common source of an accidental loop.
If the workbook is shared, add a short note explaining why an intentional circular calculation is present and which iteration settings it needs. That helps another editor avoid treating it as an error.

Troubleshooting

The Circular References submenu is empty. Confirm that you are in the correct workbook and that Excel has recalculated it. If calculation is set to manual, review File > Options > Formulas and the workbook calculation setting. You can choose Automatic if that is appropriate for the workbook, then use Formulas > Calculate Now to recalculate. Do not change a carefully configured calculation mode in a shared model without checking first. A warning may also have been caused by a formula that has since been edited, so reopen the menu after recalculation.

Excel reports a circular reference, but the listed cell is on another sheet or the status bar gives little detail. Use the address in the menu if available, then inspect the formula bar and follow references across sheets. If the status bar says Circular References without a useful address, return to the Formulas tab and check the dropdown list. The formula that completes the loop may not be on the sheet you first suspected.

The warning remains after you changed a formula. There may be another loop, or the edited formula may still reach its original cell through a different route. Open the list again and trace each remaining address. Also check whether a named range or a formula on another sheet creates a less obvious link. Make one change at a time so you can identify which edit affected the warning.

The workbook calculates but still contains a circular reference. Iterative calculation may be enabled. That setting lets Excel calculate certain circular formulas according to iteration limits; it does not prove the loop is correct. Check whether the model intentionally uses iteration, and review its expected results and settings with the workbook owner. If you need full formula-auditing controls, open the file in Excel desktop: Excel for the web may show a circular-reference warning but does not provide the same desktop navigation workflow.

You are using Excel for Mac. The desktop version has formula-auditing tools, but ribbon layout and calculation settings can vary by release. Look on the Formulas tab for Error Checking and Circular References. If the command is not visible, widen the Excel window or check the ribbon overflow. Avoid relying on Windows-only menu paths for calculation preferences; use the Mac version’s Excel preferences to review calculation settings.

Frequently Asked Questions

What does circular reference mean in Excel?
A formula has a circular reference when its result depends on itself. The dependency can be direct, such as a cell referring to itself, or indirect through one or more other formulas.

Can I find every circular reference at once?
Excel’s Circular References menu lists detected cell addresses, but you may need to inspect and resolve them one at a time. After each correction, check the menu again because another loop may become apparent.

Why does Excel not show the Circular References option?
The menu may have no entries if Excel has not detected a current loop, or the formula may have been changed since the warning appeared. Recalculate when appropriate and check the correct workbook in desktop Excel. The web version may not offer the same navigation controls.

Should I enable iterative calculation to fix a circular reference?
Usually not as a first response. Iterative calculation is useful only when the workbook intentionally uses circular formulas. For an accidental loop, correct the references instead of allowing Excel to calculate the cycle.

Can a circular reference involve two different worksheets?
Yes. A formula on one sheet can refer to a second sheet, whose formula eventually refers back to the first. Follow sheet-qualified references across the workbook until you find the return path.

Will removing a circular reference change my results?
It can. Changing a formula may alter dependent values, and disabling iteration can affect an intentional model. Save a copy, understand the calculation’s purpose, and check important outputs after making a change.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.