Circular ReferenceExcel error guide No upload

Circular Reference in Excel — Formula refers to itself

A circular reference means a formula depends on its own result, directly or through a chain of cells. Excel cannot calculate it without a starting value, so it warns you and may show 0 until the loop is broken.

Reviewed 31 October 2026 Tested in Excel 365; fixes apply to 2021, 2024 and Mac where the feature exists

The short answer

What it looks like

Excel shows a circular reference warning
A total or running balance shows 0 or does not update
The status bar says Circular References

Why Circular Reference happens

A formula in A10 includes A10 in its range, such as =SUM(A1:A10) in A10.
A running balance formula refers to the cell below it.
Two formulas refer to each other.
A named range includes the cell that contains the formula.

How to fix Circular Reference

1
Find the circular cell
Look at the status bar for the circular reference address, or use Formulas → Error Checking → Circular References. Fix the range so it does not include the result cell.
2
Exclude the total row
If the total is in A10, sum A1:A9, not A1:A10.
```
=SUM(A1:A9)
```
3
Use iterative calculation only when intended
File → Options → Formulas → Enable iterative calculation is appropriate for some models, but it can hide a genuine loop. Document the setting and the maximum iterations.
4
Restructure running balances
A running balance needs a starting balance in a separate cell and a formula that adds the current row to the previous balance.
```
=D1+C2
```

A safer formula pattern

=SUM(A1:A9)

A total placed in A10 must not include A10 itself.

Check it in your own workbook

Paste the formula into the free browser tools to see the exact fix without uploading your file. The Error Fixer explains the code, the Formula Checker finds syntax problems, and the Formula Explainer breaks down nested logic.

Open the interactive Error Fixer Check a formula

Related functions

SUM OFFSET INDIRECT

Frequently asked questions

What does Circular Reference mean in Excel?

How do I fix Circular Reference in Excel?

Find the circular cell: Look at the status bar for the circular reference address, or use Formulas → Error Checking → Circular References. Fix the range so it does not include the result cell. Exclude the total row: If the total is in A10, sum A1:A9, not A1:A10.

Why does Circular Reference appear only in some rows?

Usually because only some rows contain the trigger: A formula in A10 includes A10 in its range, such as =SUM(A1:A10) in A10. A running balance formula refers to the cell below it. Two formulas refer to each other.

How can I stop Circular Reference from appearing again?

A total placed in A10 must not include A10 itself. Use this pattern as a guard: =SUM(A1:A9)

Related Excel error guides

All error codes →

#VALUE!Wrong value type#VALUE! means Excel expected a number, date or logical value but found text, an empty cell or a value from another data type. The fix is to convert the input, remove hidden characters, or guard the calculation with IFERROR.#REF!Broken cell reference#REF! means a formula points to a cell, row, column or sheet that no longer exists. It usually appears after deleting rows or columns, moving a sheet, or pasting a formula into a workbook that does not contain the referenced sheet.#N/ALookup value not found#N/A means a lookup or match function could not find the value. The value may be missing, spelled differently, stored as text instead of a number, or surrounded by spaces. Use exact-match mode and return a clear fallback.#DIV/0!Division by zero#DIV/0! appears when a formula divides by zero or by an empty cell. Excel treats a blank denominator as zero. Check the denominator, exclude blank rows, or return a controlled blank with IFERROR.

Still stuck?

Send the workbook and get the formula fixed

A human Excel expert can repair the formula, explain the cause and return a tested workbook — usually within 24 hours. Fixed quote before work starts, from $15/hr.

Get a fixed quote Ask on WhatsApp

Circular Reference in Excel — Formula refers to itself

Reviewed 31 October 2026 Tested in Excel 365; fixes apply to 2021, 2024 and Mac where the feature exists

How to fix Circular Reference

Find the circular cell

Look at the status bar for the circular reference address, or use Formulas → Error Checking → Circular References. Fix the range so it does not include the result cell.

Exclude the total row

If the total is in A10, sum A1:A9, not A1:A10.

=SUM(A1:A9)

Use iterative calculation only when intended

File → Options → Formulas → Enable iterative calculation is appropriate for some models, but it can hide a genuine loop. Document the setting and the maximum iterations.

Restructure running balances

A running balance needs a starting balance in a separate cell and a formula that adds the current row to the previous balance.

=D1+C2