Excel Circular Reference Cannot Be Listed? How to Find It

How-to basics · Updated November 18, 2026

Excel can list detected circular references: in Excel for Microsoft 365 on Windows, go to Formulas > Error Checking ▼ > Circular References, then select a listed cell to jump to it. If that menu is empty or does not reveal the loop you expect, check calculation settings, workbook scope, and indirect formula dependencies; the list is a diagnostic aid, not always a complete explanation of how the loop works.

Where Excel lists circular references

Open the workbook that has the problem, select the Formulas tab, and look in the Formula Auditing group. Click the arrow beside Error Checking, then point to Circular References. If Excel has detected a circular reference, the submenu shows cell address or addresses associated with it. Select an address to move to that cell. The worksheet tab and cell selection help you identify where the formula is located.

Excel may also display a warning when you enter or edit a formula that creates a circular reference. If you dismiss that warning, you can still use the menu to investigate later. The status bar at the bottom of the Excel window can also show “Circular References” and an address while a circular reference is present. These indicators are useful, but they do not necessarily explain the full chain of formulas that makes a loop.

If the workbook contains several loops, inspect the listed cells one by one. A circular reference can be a single formula that refers to its own cell, or a chain in which one formula depends on another and the chain eventually returns to the first cell. Finding one address is therefore a starting point: inspect its formula and the cells it depends on before deciding what to change.

What makes a reference circular

A circular reference exists when a formula depends, directly or indirectly, on its own result. For example, a formula in cell C5 that includes C5 in the range it totals has a direct loop. A less obvious loop can run from C5 to D5, from D5 to E5, and from E5 back to C5. The formulas can be on different worksheets in the same workbook, so checking only the visible sheet may miss the source.

Not every formula that points to another cell is circular. The dependency must eventually return to the formula’s own cell. A long chain of ordinary references can be difficult to follow, especially in a model with many worksheets, named ranges, or formulas that choose references dynamically. Excel’s circular-reference menu tells you that it detected a loop and gives you a place to start; it is not a visual map of every dependency in that loop.

Why the Circular References menu may be empty

An empty submenu does not by itself prove that the workbook is free of circular references. First confirm that you are checking the workbook where the issue occurs. Circular references belong to a workbook, and a cell in another open workbook will not be identified by looking at the wrong workbook’s menu. Also check whether the workbook is still calculating or whether the formula was recently edited; use Formulas > Calculate Now to request a calculation, then check the menu again.

  • Iterative calculation is enabled. Excel can be configured to calculate circular formulas repeatedly instead of stopping with the usual warning. The loop may be intentional, but the setting can also make an accidental loop less obvious.
  • The suspected formula is not actually part of a loop. It may refer to a cell that looks related but does not lead back to the formula cell.
  • The dependency is indirect or dynamic. Functions that construct references, such as INDIRECT, can make a relationship less obvious when you inspect formulas manually.
  • The list needs to be checked again after an edit or recalculation. A correction can remove one loop while another remains, so repeat the check after changes.

Excel versions and workbook calculation states can affect what you see, so treat the menu, status bar, and formula inspection as complementary clues rather than relying on one indicator alone.

A practical way to trace the loop

Work from the address shown in the Circular References submenu. Select that cell and inspect its formula in the formula bar. Note the cells and ranges it reads, then follow those references until you find a path back to the original cell. If the formula points to a range, check whether the range includes the formula cell itself. If it points to another sheet, open that sheet and continue tracing.

  1. Record the listed cell address and worksheet name before changing anything.
  2. Inspect the formula and identify its direct precedents: the cells or ranges it reads.
  3. Follow the dependencies through the workbook, including references on other sheets.
  4. Look for a step that returns to the original cell, including a range that contains it or a named range that refers back to it.
  5. Decide whether the loop is accidental or deliberately used for iterative calculation, then correct or document it accordingly.
  6. Recalculate and reopen Formulas > Error Checking > Circular References to see whether the loop has been removed.

Trace Precedents on the Formulas tab can help show which cells feed the selected formula. It is useful for a short, straightforward chain, but tracing tools may not provide a complete map when dependencies cross worksheets or use dynamic references. Follow the addresses in the formula itself when the arrows are not enough. Make a copy before substantial edits, particularly in a shared or important workbook.

Common causes worth checking

Accidental loops often arise when a total formula includes its own cell. For instance, a total placed at the bottom of a column can become circular if its sum range extends through the total row. Another common cause is copying a formula and allowing a relative reference to shift into the formula’s own row or column. Review the selected cell’s formula and the intended range rather than assuming the problem is in the cell where you first noticed an unexpected value.

Loops can also be created across worksheets. A summary cell may depend on a detail sheet, while a detail formula depends on the summary cell. Named ranges can obscure the relationship because a formula may use a name instead of displaying an obvious cell address. Dynamic reference formulas can make dependencies harder to trace, too. When the listed cell’s formula does not appear to refer back to itself, inspect the cells it uses, names used in the formula, and formulas on other sheets before concluding that Excel has reported a false alarm.

When iterative calculation is intentional

Some workbooks deliberately use circular formulas and rely on iterative calculation to produce a result through repeated recalculation. To check the setting in Excel for Microsoft 365 on Windows, choose File > Options > Formulas, then look under Calculation options for Enable iterative calculation. The settings include a maximum number of iterations and a maximum change. They determine when Excel stops repeating a calculation; they do not prove that the model is correct.

Do not enable iterative calculation simply to make a warning disappear. It can cause Excel to calculate an unintended loop rather than alert you to it, and the result may depend on the iteration settings. If the circularity is intentional, document why it is needed and confirm that the workbook’s calculation settings are appropriate for its design. If it is not intentional, repair the dependency instead of relying on iteration.

On Mac, calculation preferences are available under Excel > Settings (called Preferences in some versions), then Calculation; labels can vary by release. Excel for the web has a different interface and may not expose the same desktop options, so use the Windows or Mac desktop app when you need to inspect or change these calculation settings.

How to prevent the problem from returning

Before copying a formula down or across, check whether its references should move and whether the destination cell will fall inside a range the formula reads. Keep totals outside the ranges they total, or adjust the range boundaries so the total cell is excluded. In models with many sheets, keep a clear separation between input cells, calculation cells, and summary outputs; this makes dependency chains easier to review.

After a major formula change, check the Circular References menu and the status bar, then review any remaining listed cells. If a loop is intentional, add a note near the calculation or in workbook documentation explaining the role of iterative calculation. These checks are particularly useful when inheriting a workbook, because calculation settings may have been saved by another person and may not match your expectations.

Frequently Asked Questions

Can Excel show every circular reference at once?
Use Formulas > Error Checking > Circular References to see the addresses Excel has detected. Select an address to navigate to it. You may still need to trace each formula’s dependencies to understand the complete loop, especially when several cells or sheets are involved.

Why does Excel say Circular References but show no useful details?
The status bar can identify a cell without explaining the dependency chain. Select the address from the Circular References submenu, inspect its formula, and follow its precedents. Check other sheets and named ranges if the formula itself does not make the loop apparent.

Does enabling iterative calculation remove a circular reference?
No. It allows Excel to recalculate a circular formula repeatedly according to configured limits. The dependency loop remains; iteration changes how Excel handles it. Only use the setting when the workbook is designed to use iterative calculation.

Can a circular reference involve another worksheet?
Yes. A formula on one worksheet can depend on a cell on another worksheet, whose formula eventually depends on the first cell. Follow the references across sheets until the chain returns to its starting point.

What should I do if the list stays empty after recalculating?
Confirm the correct workbook is active, inspect the suspected formula and its dependencies, and check whether iterative calculation is enabled. If no dependency path returns to the formula cell, the issue may be a different calculation error rather than a circular reference.

Related

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.