Formula Errors

Find Circular References in an Excel Workbook with Multiple Worksheets

Chanuka GeekiyanageChanuka Geekiyanage Nov 12, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Formulas tab

In Excel, open the workbook and select the Formulas tab on the ribbon.

2
Open Error Checking

In the Formula Auditing group, click the arrow next to the Error Checking button.

3
Display circular references

Point to Circular References in the Error Checking menu. Excel displays a submenu listing the cells involved in circular references.

4
Review each listed formula

Select each cell in the Circular References submenu, then review its formula and dependent cells to identify the calculation loop.

Check every listed worksheet: When a workbook has multiple worksheets, the listed cell references may belong to different sheets. Review every entry until the circular calculation chain is resolved.
Free Microsoft Office alternative

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.

Open and edit Excel XLSX workbooks with familiar spreadsheet toolsUse formula review and auditing features when troubleshooting spreadsheet calculationsLightweight installation for everyday spreadsheet workMaintain compatibility with Microsoft Excel XLS and XLSX formats
microsoft office alternative - wps office

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.