Excel Turn Off Circular Reference Warning?

Excel has no separate setting that simply hides circular-reference warnings while continuing to flag circular formulas. To stop the warning for a deliberate circular calculation, enable iterative calculation in Windows Excel: go to File > Options > Formulas, select Enable iterative calculation, and choose the iteration limits. If the circular reference is accidental, correct the formula instead; enabling iteration can conceal a real mistake.

Can Excel turn off the warning without changing calculation?

Not with a dedicated warning switch. Excel treats a circular reference as a calculation issue: a formula depends, directly or indirectly, on its own result. With iterative calculation off, Excel can alert you when you create or open a circular formula, and it may identify a circular reference in the status bar. The warning is a signal to investigate, not just a notification that can be dismissed permanently through a preference.

There are two different ways to make the alert stop being a problem. If the loop is intentional and designed to converge, turn on iterative calculation so Excel recalculates the formula repeatedly. If the loop is unintended, change the formulas or references so the dependency cycle is removed. Iterative calculation is not a general-purpose “ignore errors” setting: it changes how Excel calculates circular formulas in the workbook.

Dismissing an alert or saving the file does not repair a circular reference. Nor does hiding Excel’s status bar solve the underlying calculation. If your goal is simply to avoid a pop-up while preserving normal calculation and error detection, Excel does not provide a built-in option for that combination.

What a circular reference means

A circular reference occurs when a formula eventually points back to the cell containing that formula. The loop can be direct, such as a formula in A1 referring to A1, or indirect: A1 depends on B1, while B1 depends on A1. A formula may look reasonable on its own and still be circular because of a reference several cells or sheets away.

For example, a total in one cell might include the cell that contains the total. Or a tax calculation might use a final amount that already includes that tax. In each case, Excel cannot calculate a normal one-way sequence: it needs the result to calculate the input that produces that result. This can happen after copying a formula, inserting rows, changing a range, or building a model in which a payment depends on a balance that includes the payment.

A circular formula is not automatically wrong. Some financial models intentionally use a feedback calculation, such as interest that depends on an ending balance. But the model needs a clear reason for the loop and sensible stopping criteria. In an ordinary sum, lookup, or budget total, a circular reference is more often a range or cell-reference mistake.

Enable iterative calculation for an intentional loop

In Excel for Microsoft 365 on Windows, open the workbook that contains the intentional circular formula and follow these steps:

Select File > Options > Formulas.
Under Calculation options, select Enable iterative calculation.
Set Maximum Iterations and Maximum Change to values appropriate for the model.
Select OK, then check that the results are plausible and stable.

Maximum Iterations limits how many calculation passes Excel makes. Maximum Change is the amount by which a result must change for Excel to continue iterating. A lower maximum change usually asks Excel to continue until results are more stable, while a higher maximum-iteration limit allows more passes. The settings are not interchangeable: a model may need additional passes, a tighter tolerance, or both. Excel’s common defaults are 100 iterations and 0.001 maximum change, but those values are not suitable for every model.

For a simple illustration, assume A1 contains 10 and B1 is intended to represent a starting amount plus 10% of itself. In B1, enter =A1+B1*10%. This refers to B1 from within B1, so it is circular. The relationship is B1 = 10 + 0.1 × B1, whose converged result is approximately 11.111. With iterative calculation enabled and a suitable iteration limit and tolerance, Excel approaches that result over repeated passes. This example is only appropriate if that feedback relationship is genuinely what the calculation is meant to represent.

Review all circular formulas after enabling the option. Excel may calculate unintended loops too, and a displayed number is not proof that the model is correct. Iteration can stop because it reaches the maximum number of passes or because changes fall within the tolerance; neither outcome validates the assumptions.

When you should not enable it

Do not switch on iteration just to make a warning disappear if you do not understand the dependency. A formula can then return a value that looks believable but is based on an accidental loop. For instance, a SUM range that accidentally includes its own total cell may produce an unexpected result or continue changing as Excel iterates.

It is also risky to copy iterative settings into a workbook without explaining the model. Someone opening the file may see calculated values without realizing that a circular calculation is active. Document why the loop exists, which cells participate, and what limits were chosen. If a model is shared, ask another reviewer to inspect its logic rather than relying on the absence of a warning.

Iteration is a calculation method, not a repair for every formula problem. If a loop does not converge, the result may depend on the starting values and calculation settings. If it oscillates or grows instead of settling, increasing the iteration count does not necessarily fix the model. Rework the calculation or use a non-circular method where possible.

Find and remove an accidental circular reference

When iterative calculation is off, Excel provides a route to locate circular-reference cells. On Windows, select Formulas > Error Checking > Circular References. If Excel has detected a circular reference, the menu can list a cell address; select an address to move to that cell. If there are several loops, inspect the listed cells and follow their precedents rather than assuming the first one is the only cause.

Then inspect the formula and its inputs. Useful checks include:

Look for a total formula whose selected range includes the total cell itself.
Check whether a copied formula shifted a reference into the formula’s own row or column.
Follow references across worksheets; a loop can pass through multiple sheets before returning to its starting cell.
Use the formula-auditing commands on the Formulas tab, such as Trace Precedents and Trace Dependents, to see relationships between cells.
Correct the reference, move the total outside the summed range, or restructure the calculation, then recalculate and confirm the alert is gone.

Some circular references are harder to spot when formulas use named ranges or indirect references, or when several sheets are involved. Check defined names in Formulas > Name Manager if a formula’s displayed cell references do not explain the loop. Also make sure you are investigating the workbook that actually contains the formula; a warning may concern a different sheet from the one currently visible.

Why the warning may still appear

If you enabled iterative calculation but still see a warning, first verify the setting in the workbook where the formula is located. Check File > Options > Formulas again, and confirm that Enable iterative calculation is selected. If the workbook was copied, downloaded, or opened in a different Excel environment, check its calculation settings there too.

Next, identify whether the message refers to a new circular reference or one that already existed. A workbook can contain more than one loop, and editing another formula can create an additional one. Use Formulas > Error Checking > Circular References to inspect the available cell addresses, then check the formula relationships. If iteration is enabled, the workbook may calculate a circular formula without making the loop correct; troubleshoot the result as well as the alert.

Calculation mode can also confuse diagnosis. Automatic versus manual calculation affects when formulas recalculate, not whether a dependency is circular. Changing calculation mode is therefore not a reliable way to turn off the circular-reference warning.

Windows, Mac, and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. On Mac, open Excel > Settings > Calculation (called Preferences in some older releases), then select Use iterative calculation and set the available limits. Menu wording can vary slightly by release, but the setting is in Excel’s calculation preferences.

Excel for the web does not use the Windows File > Options dialog. If you need to change iterative-calculation settings or investigate a circular formula in detail, open the workbook in the desktop app and use the relevant desktop calculation options. When a workbook is shared between desktop and web, check the results in the environment where the workbook will be used; calculation behavior and available controls can differ by app and version.

Frequently Asked Questions

Can I disable only the circular reference pop-up in Excel?
No separate Excel setting disables only that warning while leaving circular-reference detection and normal calculation unchanged. Use iterative calculation only for an intentional loop, or remove the loop if it is accidental.

Does enabling iterative calculation fix the formula?
No. It tells Excel to recalculate circular formulas repeatedly, subject to iteration limits. It does not correct an incorrect range, validate the model, or guarantee that the result converges.

Where do I find the circular reference in Excel?
On Windows, select Formulas > Error Checking > Circular References and choose a listed cell address if one appears. Then trace its precedents and dependents, including references on other worksheets.

Why does my total create a circular reference?
A common cause is including the total cell in its own SUM range. Check the range boundaries and whether copying or inserting rows changed them. Move the total outside the range or adjust the references to exclude the total cell.

Will changing to manual calculation hide the warning?
Manual calculation controls when Excel recalculates formulas; it does not remove a circular dependency or provide a proper warning-suppression option. Fix the formula or deliberately configure iterative calculation instead.

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.