Excel Stop Circular Reference Warning? Fix or Allow It

To stop an Excel circular reference warning, first remove the formula loop using Formulas > Error Checking > Circular References to find the cell involved, then correct the formula. If the circular calculation is intentional, enable File > Options > Formulas > Enable iterative calculation on Windows; this allows Excel to calculate the loop, but it does not repair it or make its results automatically reliable.

What the circular reference warning means

A circular reference occurs when a formula depends on its own result. The dependency can be direct, when a cell refers to itself, or indirect, when a chain of formulas eventually leads back to the starting cell. Excel warns because it cannot calculate an ordinary formula in a simple one-way sequence: the result depends on a value that has not yet been settled.

For example, suppose A1 is intended to total the values below it, in A2 through A10. If the formula is entered in A1, the following version includes its own result in the range:

With the total in A1 and the values to add in A2:A10, the accidental formula is =SUM(A1:A10).

Use this instead: =SUM(A2:A10).

A more subtle loop can involve multiple cells. If A1 refers to B1, B1 refers to C1, and C1 refers back to A1, none of those formulas visibly refers to itself, but the chain is still circular. The warning is about the dependency path, not necessarily a formula that repeats its own cell address.

Find the cell Excel has flagged

On Excel for Microsoft 365 on Windows, select Formulas > Error Checking > Circular References. The menu lists detected circular-reference cells; select an address to jump to that cell. If there is more than one loop, inspect each listed address and the formulas that feed into it. Correcting one loop may reveal another, so check the menu again after editing.

Open the Formulas tab.
Choose Error Checking, then Circular References.
Select a cell address from the list and inspect its formula in the formula bar.
Trace the referenced cells, including formulas that refer indirectly back to the flagged cell.
Correct the formula or decide deliberately whether the model needs iteration.

Excel may also show Circular References in the status bar. The status bar can help confirm that a loop remains, but it is not a detailed explanation of the dependency chain. If you cannot find the command in a particular layout, use the Formulas tab and its Error Checking menu rather than relying on a warning popup that may already have been dismissed.

On Mac, use the Formulas tab and look for Error Checking and Circular References; ribbon wording and arrangement can vary slightly by release. Keyboard shortcuts for opening the Windows Error Checking menu are not a dependable substitute for the cell list, so using the ribbon is the clearest route. Excel for the web has fewer desktop calculation controls; open the workbook in the desktop app if you need to change iterative-calculation settings.

Fix the formula instead of hiding the warning

Most accidental circular references come from a range that includes the formula cell, a copied formula with a shifted reference, or a total placed inside the data it totals. Check the intended inputs and outputs before changing references. A formula can be syntactically valid while still including the wrong cells, and simply removing the warning is not proof that the result is correct.

Check the formula range. A total above a list should generally sum the rows below it, not a range that includes the total cell.
Inspect copied formulas. Relative references change as formulas are filled across or down. Confirm that a reference did not shift into a cell that eventually points back to the formula.
Separate inputs from calculations. Keep user-entered values and calculated results in distinct cells or areas where practical. This makes dependency paths easier to review.
Trace the chain. Select a referenced cell and continue checking its formula until you find the link that returns to the original cell.
Recheck the workbook. After edits, recalculate and review the Circular References list again, especially if formulas were copied across several sheets.

For instance, a total in a row at the bottom of a table may accidentally include its own row. Likewise, a formula copied from a neighboring column might refer to a result cell rather than an input. In both cases, the sensible repair is to correct the range or reference, not to ask Excel to iterate around the mistake.

When iterative calculation is appropriate

Some models are intentionally circular. A calculation may depend on a value that itself depends on the calculation, and the model is designed to approach a stable answer through repeated recalculation. In that case, enabling iteration can be appropriate, provided the workbook owner understands the logic and checks that the results converge to a useful value.

On Windows, go to File > Options > Formulas. Under Calculation options, select Enable iterative calculation. Excel provides controls for Maximum Iterations and Maximum Change. Maximum Iterations limits how many calculation passes Excel makes; Maximum Change is the threshold used to decide whether successive results have changed little enough to stop. Excel’s usual defaults are 100 iterations and 0.001 maximum change, but review the values shown in your workbook rather than assuming they have not been adjusted.

A low iteration limit may stop a calculation before it settles. A very small maximum-change threshold can require more passes, while a larger threshold can stop sooner with a less precise result. The right settings depend on the model and its units; there is no universally correct pair. Check that the result is stable when you adjust the settings modestly and that the model’s logic is documented.

On Excel for Mac, open Excel > Settings (called Preferences in older releases) > Calculation and select Use iterative calculation. The wording and placement may differ by version. The Windows File > Options path does not apply to Mac. If you are working in a browser and cannot find an iteration control, open the file in desktop Excel to configure it.

Why enabling iteration is not the same as fixing the formula

Enabling iterative calculation changes how Excel handles circular formulas; it does not remove the dependency loop. It can suppress the warning for an intentional model, but it can also allow an accidental loop to produce a number that looks plausible. That number might depend on the previous value, the iteration limit, or the maximum-change threshold, so it should not be accepted without checking the calculation design.

Iteration can also affect other circular formulas in the workbook, not just the one that prompted the warning. Before changing the setting, identify the circular references and confirm which ones are intentional. If you disable iteration later, circular formulas may once again trigger warnings or fail to calculate as intended. When the workbook is shared, tell other users that it relies on iterative calculation and explain any non-default settings they need to preserve.

Can you turn off only the warning?

Excel does not provide a simple, separate switch that hides circular-reference warnings while leaving ordinary circular formulas to calculate normally. Clicking OK dismisses the current message, but it does not remove the loop or guarantee that Excel will never alert you again. Enabling iterative calculation is the relevant setting when a circular model is deliberate, but it changes calculation behavior rather than merely hiding a notification.

If the warning appears in a workbook that should not contain circular formulas, keep iteration off and fix the dependency. If the circular formula is intentional, document it and test the output. This distinction matters when handing a workbook to someone else: a silent result is not necessarily a correct result.

Common causes and checks before sharing

A circular reference can be introduced by an edit that seems harmless, such as expanding a SUM range, inserting a row, or copying a formula across a block. It may also be present in a template or in formulas spread across multiple worksheets. When a warning first appears, consider what changed most recently, but still trace the references rather than assuming the last edited cell is the only cause.

Before sending the workbook, review the circular-reference list, confirm that each remaining loop is intentional, and test important outputs after recalculation. If the file uses iterative calculation, record the reason and the settings somewhere readers can find them. If you repaired a mistaken formula, compare the corrected result with a simple independent check, such as adding a short set of inputs manually. This is particularly useful when totals or key outputs will guide later work.

Frequently Asked Questions

How do I remove a circular reference in Excel?
Use Formulas > Error Checking > Circular References to locate a listed cell, then trace its formula references and change the range or dependency that closes the loop. Recheck the list after making the correction.

Can I ignore the Excel circular reference warning?
You can dismiss the message, but ignoring it does not correct the formula. Only allow the circular calculation if the loop is intentional, its behavior is understood, and the result has been checked.

Does enabling iterative calculation fix a circular reference?
No. It lets Excel recalculate circular formulas repeatedly according to iteration settings. The loop remains, and a mistaken formula can still produce an unreliable result.

Why does Excel show a circular reference when I cannot see one?
The loop may be indirect, passing through other cells or worksheets before returning to the starting formula. Use Excel’s Circular References list and inspect each formula along the dependency path.

Can I disable the warning without enabling iteration?
There is no general setting that simply suppresses the warning while leaving circular formulas unchanged. Fix an unintended loop, or enable iteration only when the circular calculation is deliberately part of the model.

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.