Excel circular calculation error

Question

I keep getting a pop-up message about a circular calculation error in my Excel workbook. My workbook has more than 20 tabs which makes it impossible to locate and resolve the issue. Does anyone have a better way to find the error?

Thank you in advance. This is driving me to the brink.

Answer 1

Use Excel’s built‑in circular reference tools; they work across the whole workbook, including all tabs.

1. On the ribbon, go to Formulas.
2. Click the arrow next to Error Checking.
3. Point to Circular References.
4. In the submenu, click the first cell address shown. Excel will jump directly to a cell that participates in a circular reference.
5. Review and fix the formula in that cell (for example, move the formula to another cell or change it so it does not refer to itself directly or indirectly).
6. Repeat steps 1–5, choosing the next cell in the Circular References submenu each time, until the status bar at the bottom no longer shows Circular References.

Additional helpers when it is hard to see how cells depend on each other:

1. With a problematic cell selected, on Formulas use Trace Precedents and Trace Dependents to show tracer arrows between related cells, even across sheets.
2. Double‑click a tracer arrow to move between cells in the circular chain.

Excel also shows Circular References in the status bar (lower‑left). If circular references exist only on other sheets, the status bar shows Circular References without a cell address; use the Circular References submenu as above to jump to them.

If a formula is in its own cell (for example, =D1+D2+D3 in cell D3, or =SUM(A3:F3) in F3, or =(A1+A2)/A3 in A3), move it to another cell or change the references so the formula no longer includes its own cell.

In rare cases where circular references are intentional (for iterative calculations), see Remove or allow a circular reference for guidance on enabling and controlling iteration.

---

References:

• Remove or allow a circular reference in Excel
• How to avoid broken formulas in Excel