Excel Circular Reference Popup: How to Find and Fix It

Errors & fixes · Updated November 18, 2026

The Excel circular reference popup means a formula, directly or through other cells, depends on its own result. To find the problem, go to Formulas > Error Checking > Circular References, select a listed cell, and correct the formula; enable iterative calculation only when the circular logic is intentional.

What the circular reference popup means

A normal formula gets its inputs from other cells and returns a result. A circular reference occurs when Excel cannot follow that chain to a starting value because the formula eventually leads back to itself. The loop might be within one cell, or it might pass through several cells before returning to the first.

For a direct example, if A1 is intended to hold a value, putting =A1+1 in A1 makes the cell depend on its own result. Excel cannot calculate a first value from that instruction alone. When you enter or edit a formula that creates a loop, Excel may show a warning dialog saying there are one or more circular references. With iterative calculation off, the cell may show zero or a previous value, and Excel may identify the circular-reference cell on the status bar.

The popup is a warning about calculation logic, not proof that the workbook is damaged. Sometimes the loop is an accidental range or cell-reference mistake. In other workbooks, a circular formula is deliberate and relies on repeated calculation. The right response depends on whether the formula was meant to loop.

How to find the cell causing it

In Excel for Microsoft 365 on Windows, open the Formulas tab, choose the Error Checking dropdown in the Formula Auditing group, and point to Circular References. Excel lists a cell address when it can identify one. Select an address to jump to that cell. If there is more than one loop, check the list and investigate each reference; fixing one loop may reveal another.

You can also look at the status bar at the bottom of the Excel window. When Excel has identified a circular reference, it may display a message such as “Circular References” followed by a cell address. If the status bar is hidden or the address is not visible, use the Formulas menu instead.

Once you are in a flagged cell, inspect the formula bar and its references. To see related cells visually, use Formulas > Trace Precedents to show cells that feed the selected formula, or Formulas > Trace Dependents to see cells that rely on it. Follow the arrows through the calculation chain. These tools help map relationships, although they may not make a complicated loop obvious immediately. Remove arrows with Formulas > Remove Arrows when you are done.

On Mac, the Formula Auditing tools are available from the Formulas tab, though ribbon layout can vary by Excel release. Excel for the web has a more limited set of auditing controls than the desktop app; if you cannot locate the loop there, open the workbook in Excel for Windows or Mac and use the ribbon tools.

Direct and indirect circular references

A direct circular reference is the easy-to-spot case: a formula in a cell refers to that same cell. For instance, if A1 is meant to contain a count, entering =A1+1 in A1 creates a direct loop. A formula cannot use its own uncalculated result as a starting point unless the workbook is deliberately using iterative calculation.

An indirect circular reference involves two or more cells. For example, if A1 contains =B1+1 and B1 contains =A1-1, A1 depends on B1 and B1 depends on A1. There is no independent input that breaks the cycle. Longer loops can pass through many rows, sheets, or named ranges, so a formula that looks harmless by itself may still be part of a circular chain.

When checking formulas, consider both direct cell addresses and named ranges. A name can refer to a range that includes the formula cell, making a loop less obvious. Also check formulas on other worksheets: a cell on one sheet can depend on a result on another sheet that eventually points back to the first.

Common reasons the warning appears

The most frequent cause is including a total cell in the range it is supposed to total. Suppose B2:B5 contain 12, 8, 5, and 10, and B6 is the total. If the formula in B6 is =SUM(B2:B6), the range includes B6 itself. Replace the range with the data cells only, as shown later.

Other common causes include copying a formula into the wrong row, selecting an adjacent cell by mistake, or changing a reference while editing a formula. A formula intended for a row of data can become circular if its copied range expands to include its own output. A chain of formulas can also loop after a workbook is reorganized or a cell is repurposed.

  • Totals and subtotals: a sum includes its own total cell or a subtotal that already includes the same data.
  • Copied formulas: a relative reference shifts unexpectedly when a formula is filled down or across.
  • Cross-sheet dependencies: formulas on different worksheets refer back to one another.
  • Named ranges: a name points to a range that contains the formula using that name.
  • Deliberate models: a calculation is designed to repeat until it approaches a stable result.

How to fix an accidental circular reference

First decide what the formula is supposed to calculate. Do not just delete a reference to make the popup disappear: doing so may produce a number that looks plausible but is incomplete. Check the intended input range, the cells that should be included, and whether the formula belongs in the selected cell.

In the example above, with the four values in B2:B5 and the total in B6, replace the formula in B6 with =SUM(B2:B5). The result is 35 because 12 + 8 + 5 + 10 = 35. The corrected range stops before the total cell, so the formula does not refer to itself.

If the error came from a copied formula, compare the affected row with a neighboring row that works. Check whether references should move as the formula is copied or stay fixed. In the formula bar, correct the reference or restore the intended formula, then press Enter. Afterward, revisit Formulas > Error Checking > Circular References and confirm the loop is gone.

For complicated workbooks, trace the dependency chain one cell at a time. Identify which value should be an input and which should be a calculated output. If a cell is serving both roles, separate those jobs into different cells. A clear input cell and a separate result cell often eliminate the loop without changing the model’s purpose.

When iterative calculation is appropriate

Some models intentionally use a circular formula to refine a result through repeated calculations. Excel can allow this behavior through iterative calculation. In Excel for Microsoft 365 on Windows, choose File > Options > Formulas, select Enable iterative calculation, and review the Maximum Iterations and Maximum Change settings. These settings determine how many repetitions Excel allows and how small a change must be before it stops. Common default values are 100 iterations and 0.001 maximum change, but workbook settings can differ.

For a simple illustration, if A1 is the only cell in the model and the intended equation is x = (x + 10) / 2, put =(A1+10)/2 in A1 and enable iteration. Starting from an initial value, repeated recalculation moves the result toward 10. It approaches that value rather than producing it from a single ordinary calculation, so the chosen iteration limit and tolerance affect the displayed result.

Do not enable iteration just to silence a warning. It can make unintended loops calculate without fixing the underlying logic, and it may affect other circular formulas in the workbook. Before enabling it, confirm that repeated calculation is part of the model design, check whether results settle as expected, and document the setting for anyone who uses the file. On Mac, look under Excel > Settings (or Preferences in some releases) > Calculation for the iterative-calculation controls; labels can vary by version.

If the popup keeps returning

If the warning returns after you edit a formula, another loop may remain, or the corrected formula may still reach the original cell through a different chain. Recheck the Circular References list, then trace the dependencies of each listed cell. Look across all relevant worksheets, not just the sheet that was active when the message appeared.

Also check whether iterative calculation is already enabled. A workbook configured for iteration may not display the same warning behavior as one with iteration disabled, and it can show a calculated value for an intentional loop. If the workbook behaves differently on another computer, compare its calculation settings and Excel version before assuming the formulas changed.

When a warning appears but you cannot find a listed address, save a copy and inspect recently edited formulas, named ranges, and formulas on hidden or distant worksheets. You can also use Find to search for formulas or review the workbook’s defined names. Avoid clearing formulas at random: a circular warning identifies a dependency problem, and preserving the workbook’s logic matters more than merely dismissing the dialog.

How to prevent circular-reference mistakes

Keep raw inputs, intermediate calculations, and final outputs in separate cells or clearly separated sections. For totals, select only the rows that hold source data, and verify that a subtotal is not counted again in a grand total. When copying formulas, inspect the first and last rows of the filled range, where an off-by-one reference is easy to miss.

For shared or complex workbooks, label input and output cells, use consistent worksheet layouts, and review formula dependencies after moving or inserting rows and columns. If a circular calculation is intentional, explain why it is needed and record the iteration settings. These small checks make it easier for someone else to distinguish a designed loop from an accidental one.

Frequently Asked Questions

Is a circular reference always an error?
No. It is usually an accidental formula loop, but some models intentionally use iterative calculation. Confirm the design before deciding whether to break the loop or allow iteration.

Where is Circular References in Excel?
On Windows, go to Formulas > Error Checking in the Formula Auditing group, then select Circular References. Excel lists a cell address when it has identified one.

Why does Excel show a circular reference when my formula looks correct?
The formula may depend on another cell that eventually depends on the original cell. Check other worksheets, named ranges, and subtotal formulas, not only the formula visible in the flagged cell.

Can I ignore the circular reference popup?
Only if the loop is intentional and the workbook is configured to calculate it as designed. Otherwise, ignoring the message can leave incorrect, stale, or misleading results in the workbook.

How do I stop the popup without changing the formula?
If the circular calculation is intentional, enable iterative calculation and choose suitable iteration settings. If it is not intentional, the reliable fix is to correct the dependency loop rather than suppress the warning.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.