Excel Remove Circular Reference Warning: What to Do

To remove Excel’s circular reference warning, find and correct the formula that refers to its own cell, either directly or through other formulas. If the circular calculation is intentional, enable iterative calculation instead; Excel has no separate setting that simply hides the warning while leaving the calculation unchanged.

What the circular reference warning means

A circular reference exists when a formula depends on its own result. The dependency can be direct, as when a formula in A1 refers to A1, or indirect, as when A1 depends on B1 and B1 depends on A1. Excel flags this because it cannot calculate an ordinary formula chain in the usual one-pass order: it needs a value from a calculation that has not yet finished.

The warning is about the workbook’s calculation logic, not necessarily a damaged file. A circular reference may be accidental—for example, a total formula that includes its own cell—or deliberate, as in some models that calculate a balance and the interest on that balance together. The right response depends on which kind you have. If it is accidental, repair the dependency. If it is intentional, use iterative calculation only after checking that the calculation has a sensible, stable result.

Why Excel shows the warning

Excel normally recalculates formulas by following their dependencies. If a formula needs a value that, in turn, depends on the first formula, calculation can loop. Excel warns you so you can inspect the formulas rather than silently rely on a result that might be incomplete, stale, or different from what you intended.

A circular reference can appear after editing a formula, copying a formula into a range, or changing the layout of a workbook. For instance, a SUM formula intended to total rows 2 through 10 can accidentally be placed in row 10 and include its own cell in the range. Similar problems arise when a percentage or balance formula refers to a total that already includes that percentage or balance.

Seeing the warning does not prove that every number in the workbook is wrong. It does mean that at least one formula has a circular dependency and that you should identify it before trusting affected results. Other formulas may calculate normally, but values downstream from the circular formula can be affected.

Find the formula causing the warning

In Excel for Microsoft 365 on Windows, use the circular-reference list on the Formulas tab. Open Formulas > Error Checking > Circular References, then select a cell shown in the menu to go to it. Excel may show more than one cell as you work through the problem; fixing one loop can reveal or leave another one to check.

Check the selected cell’s formula in the formula bar. Look for the cell itself in its formula or in a range that includes it.
Use Formulas > Trace Precedents to inspect cells the formula depends on. Follow the arrows and examine the related formulas for a loop.
Check the status bar at the bottom of the Excel window for a circular-reference notice and a cell address, if shown.
If the reference crosses worksheets, inspect the formulas on each sheet in the dependency chain. A loop can be indirect even when no single formula mentions its own cell.

The menu is a starting point, not always a complete explanation of the logic. For a complicated workbook, write down the chain of cells involved or inspect formulas one link at a time. On Mac, the ribbon’s Formulas tab also provides formula auditing and circular-reference commands, though exact menu labels or placement can vary by Excel version. In Excel for the web, the desktop Excel app may be needed for the full set of formula-auditing and iterative-calculation controls.

Fix an accidental circular reference

First decide what the formula is meant to calculate, then adjust the reference so the formula no longer depends on its own result. Do not change a formula just to make the warning disappear if that would alter the intended calculation. Check the affected totals or outputs after the edit.

For example, suppose a total belongs in B11 and should add the values in B2:B10. With the total in B11 and source values in B2:B10, the correct formula is =SUM(B2:B10). If the formula is instead placed in B10 and sums B2:B10, it includes its own cell and creates a circular reference. Move the total below the data or correct the range so it contains only the intended input cells.

Another common cause is a formula that should refer to an input cell but instead points to its own output cell. Check copied formulas carefully: relative references shift when formulas are filled, and a formula that worked in one row can become circular in another. If the intended calculation can be expressed in a separate helper cell, splitting the steps often makes the logic easier to review and removes the loop.

After changing a formula, revisit Formulas > Error Checking > Circular References. Confirm that the list no longer identifies the repaired cell, then check the displayed result and any downstream totals. If the list still shows a reference, continue inspecting the remaining cells rather than assuming the first edit fixed every loop.

When an intentional circular reference makes sense

Some models intentionally calculate values that depend on one another. A simplified example is a balance that includes an amount calculated as a percentage of that same final balance. The dependency is circular by design, so ordinary one-pass calculation is not enough. Iterative calculation tells Excel to recalculate the loop repeatedly until it reaches a stopping condition.

This approach is appropriate only when repeated calculations are part of the model’s intended method. It is not a general repair for a warning. Before enabling it, document which formulas form the loop, what result should converge toward, and what should happen if the calculation does not settle. If the model can instead be rewritten as a direct formula without a loop, that is often simpler to audit.

One potential source of confusion is that a circular formula may appear to produce a plausible number. That number alone does not prove the model is correct: it may depend on iteration settings, initial values, or the workbook’s calculation state. Compare the result with an independently calculated check where possible.

Enable iterative calculation in Excel

In Excel for Microsoft 365 on Windows, open File > Options > Formulas. Under Calculation options, select Enable iterative calculation, set the maximum iterations and maximum change if needed, and select OK. On Mac, open Excel > Settings (called Preferences in some releases), choose Calculation, and look for the iterative-calculation option. Labels can differ slightly by release.

Maximum iterations limits how many recalculation passes Excel makes. Maximum change sets the threshold at which Excel treats the result as sufficiently settled. A smaller maximum change can require more passes; a low iteration limit or an unsuitable threshold can leave a result that has not converged as intended. Excel provides default values, but those are not proof that a particular model’s output is accurate. Choose settings based on the model and verify the result.

Keep in mind that enabling iteration changes how Excel handles circular formulas; it does not remove their dependencies. Save the workbook after setting up the model, and tell anyone who uses it that the circular calculation is intentional. If the workbook is opened in another Excel environment, confirm that its calculation behavior and settings produce the expected results.

Common problems and misconceptions

“I only want to dismiss the pop-up.” There is no separate ignore-warning switch that guarantees the same calculation without addressing the loop. Fix the formula or deliberately use iterative calculation.
“The formula does not mention its own cell.” It may still be circular indirectly. Follow the chain of referenced cells until it returns to the starting formula.
“I fixed one cell, so the workbook is clear.” There may be another loop. Recheck the circular-reference list after each repair.
“Iteration makes any circular formula safe.” It only allows repeated calculation. A poorly designed loop can fail to converge or produce an unintended result.

Also distinguish the warning from other Excel errors, such as #REF! or #VALUE!. Those errors have different causes and are not removed by changing iterative-calculation settings. If the warning returns after an edit, undo or inspect the latest formula changes and check whether a copied range introduced a new dependency.

Frequently Asked Questions

Can I turn off the circular reference warning without fixing the formula?
No separate warning-only switch removes the underlying circular dependency while preserving normal calculation behavior. You can enable iterative calculation for a deliberate loop, but that changes how Excel calculates it and should be used only when the loop is intentional.

Where is the circular reference listed in Excel?
On Windows, check Formulas > Error Checking > Circular References. Select a listed cell to jump to it. The status bar may also show a circular-reference notice or a cell address.

Why does Excel say there is a circular reference when I cannot see one?
The loop may pass through other formulas, including formulas on another worksheet. Follow precedents from the reported cell and inspect each linked formula until you find the chain that leads back to the starting cell.

Will enabling iterative calculation fix every circular reference?
No. It permits Excel to recalculate circular formulas repeatedly, but it does not correct accidental references or guarantee a stable, meaningful result. Review the formulas and verify that any intended loop converges appropriately.

Does iterative calculation affect the whole workbook?
It affects how circular formulas are calculated in the workbook, rather than repairing just one cell. Check the model’s behavior after enabling it, and make sure other users who rely on the workbook understand that it contains intentional circular calculations.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.