Find Circular References in an Excel Workbook with Multiple Worksheets
Question details
The user needs to locate circular references in an Excel workbook that contains multiple worksheets.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The workbook has a circular reference, but Excel's error message does not identify where it occurs.
- Observed behavior
- Excel can list the cells involved in circular references through the Formula Auditing tools.
Open the workbook in desktop Excel and make sure the Formulas tab is visible on the ribbon. If the workbook contains many sheets, note the sheet names so you can review each listed cell efficiently.
Use Error Checking to list circular reference cells
Use this method when Excel does not identify the circular reference location in the workbook.
Excel's Circular References menu lists the cells involved in detected circular calculations, including cells located on different worksheets. Select each entry to jump to the affected cell and inspect its formula.
In Excel, open the workbook and select the Formulas tab on the ribbon.
In the Formula Auditing group, click the arrow next to the Error Checking button.
Point to Circular References in the Error Checking menu. Excel displays a submenu listing the cells involved in circular references.
Select each cell in the Circular References submenu, then review its formula and dependent cells to identify the calculation loop.
Work with Excel-compatible spreadsheets in WPS Office
WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong Microsoft Excel compatibility. Open and edit XLSX workbooks, review formulas, and migrate your spreadsheet workflow with minimal changes.

Frequently Asked Questions
Where is the Circular References command in Excel?
Open the Formulas tab, click the arrow next to Error Checking in the Formula Auditing group, and point to Circular References.
Can Excel find circular references on another worksheet?
Yes. Excel can list circular-reference cells located on different worksheets. Select each entry in the Circular References submenu to jump to the corresponding cell.
What should I inspect after selecting a circular-reference cell?
Review the selected cell's formula and trace the cells it references. Look for a chain that eventually points back to the original cell, either directly or through other formulas.
Why does Excel show a circular reference warning without naming the cell?
The warning may identify only that a circular calculation exists. Use Formulas > Error Checking > Circular References to display the affected cell references.




