Excel Circular Reference: How to Find and Fix It

In Excel for Microsoft 365 on Windows, go to Formulas > Error Checking > Circular References, then select a listed cell to jump to it. Excel reports a circular reference when a formula depends on its own result, either directly or through other cells.

What a circular reference means

Ordinary spreadsheet calculations flow from inputs to results. A circular reference creates a loop in that flow: Excel must calculate a cell to get its value, but that calculation depends on a value that cannot be determined until the first cell is calculated. The loop might involve just one formula or several cells, and it can cross worksheets.

A direct circular reference is a formula that points to its own cell. With the formula entered in A1, the cell layout is simply A1 containing the formula; =A1+1 refers to A1 while Excel is calculating A1. With iterative calculation turned off, Excel identifies this as circular rather than producing a normal, dependable result.

An indirect loop can be harder to spot. For example, with B1 and C1 as the two cells in the loop, enter =C1+1 in B1 and =B1-1 in C1. Each formula depends on the other cell, so neither can be calculated independently. Real workbook loops may involve many intermediate formulas, making Excel’s cell list and formula-tracing tools useful.

Find a circular reference from the Formulas tab

Use this route in Excel for Microsoft 365 on Windows:

Open the workbook and select the Formulas tab.
In the Formula Auditing area, open the Error Checking drop-down.
Point to or select Circular References. Excel displays the cell address or addresses it has identified.
Select an address in the list to move to that cell. Check the formula bar and the worksheet name to confirm where the formula lives.
After making a correction, check the same menu again. If Excel finds another loop, continue investigating until the Circular References list is empty.

The menu lists cells involved in circular references, but it does not necessarily explain the whole chain or tell you which formula reflects the underlying modeling mistake. Treat each listed address as a starting point: inspect its formula and the cells it uses. If the menu has no Circular References entry, Excel has not identified an active circular reference in the workbook at that time.

Use the status bar and inspect the formula

Excel may also show a circular-reference notice and a cell address on the status bar at the bottom of the window. This can be a quick clue while you work, but the Formulas tab is a better place to review the available cell addresses and navigate to them. If several loops are present, the status bar may not identify every one, so do not rely on it as a complete inventory.

Once you reach a flagged cell, read its formula from the formula bar. Look for a direct reference to the cell itself, then follow the referenced cells in turn. A formula can be circular even if its own text does not include its address: the reference may be several formulas away, or may travel to another worksheet and back. Check both the formula and the intended calculation, since a cell reference can be syntactically valid but point to the wrong range.

Excel’s auditing arrows can help make a dependency path visible. Select a cell and use Formulas > Trace Precedents to show cells that feed into it, or Formulas > Trace Dependents to show cells that use it. These tools may need to be applied more than once to follow a longer chain. They are aids for inspection, not a substitute for checking the formulas themselves. Use Remove Arrows on the Formulas tab when you want to clear the displayed arrows.

Trace a loop across cells or worksheets

Start with a cell Excel lists, then write down each cell its formula depends on. Continue following references until you return to the starting point. For example, if B1 uses C1, C1 uses D1, and D1 points back to B1, the loop spans three cells even though none of the formulas necessarily refers to itself directly. If a reference includes a worksheet name, switch to that sheet and continue the same process.

For a large model, use the Name Box to jump to a cell address, and check worksheet tabs as you follow the references. You can also select formula cells and inspect the formula bar one at a time. Avoid assuming that the first flagged cell is the only problem: fixing one loop can expose another, and a workbook may contain more than one independent cycle.

It helps to distinguish the loop from its cause. The loop is the chain of dependencies Excel detects. The cause might be a mistaken cell address, a copied formula that shifted into the wrong column, a total included in its own sum range, or a deliberate calculation design. Finding the chain shows where the problem is; deciding which input, formula, or model rule should change requires understanding what the worksheet is meant to calculate.

Fix an accidental circular reference

Do not simply remove a reference because Excel reports it. First decide what the formula is supposed to calculate, then break the dependency at the point that violates that design. Common corrections include:

Correct a mistaken reference. A copied formula may point to its own cell or to a result cell instead of the intended input.
Check totals and ranges. If a total cell is included in the range it is totaling, the total depends on itself. Adjust the range so it contains the intended inputs, not the total cell.
Separate inputs from outputs. Put assumptions or manual entries in dedicated cells and calculate results in different cells. This makes dependencies easier to follow.
Review links between sheets. A formula on one sheet may point to a summary cell that ultimately points back to the original sheet.
Recheck copied formulas. Relative references shift when formulas are filled or copied. Confirm that each row and column points to the right source cells.

After changing a formula, review the displayed value and confirm it makes sense for the worksheet’s inputs. Then revisit Formulas > Error Checking > Circular References. A disappearing warning confirms the detected loop is gone; it does not, by itself, prove that the replacement formula is logically correct.

When iterative calculation is appropriate

Some models deliberately use circular calculations and rely on Excel to repeat calculations until the results settle within a specified tolerance or reach a maximum number of iterations. This is called iterative calculation. It can be appropriate when a model is explicitly designed to solve a circular dependency, but it should not be used as a quick way to silence an unexpected warning. If the loop is accidental, enabling iteration can conceal a formula error and return results that are difficult to interpret.

In Excel for Microsoft 365 on Windows, the setting is under File > Options > Formulas. Select Enable iterative calculation, then review the maximum iterations and maximum change settings. The maximum iterations limit how many calculation passes Excel makes; maximum change sets a tolerance for deciding when the result is close enough to stop. The right values depend on the model, and a setting that is too loose or too restrictive can affect results or calculation time.

Before enabling iteration, document why the circular dependency is intentional, which cells participate, and how the stopping settings affect the answer. Test the workbook with known or independently checked inputs. If you cannot explain why repeated calculation is required and what result it should converge to, investigate the formulas instead of turning iteration on.

Excel for Mac and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. Excel for Mac also has circular-reference checking on the Formulas tab, though the arrangement of ribbon controls can differ. For calculation settings, look under Excel > Preferences or Excel > Settings, then Calculation; the wording and availability can vary with the Mac release. If you cannot find a command in the ribbon, use Excel’s command search or open the workbook in the desktop app.

Excel for the web has a different interface and may not offer the same circular-reference navigation and calculation-setting controls as the desktop version. If you need to follow the desktop steps, inspect a complex dependency chain, or change iterative-calculation settings, open the workbook in Excel for Windows or Mac. Avoid making a change in one version and assuming that every calculation option is exposed the same way in another.

Common reasons the warning persists

If a warning remains after you edit a formula, Excel may have found a second loop, or your change may have redirected the dependency without breaking it. Reopen the Circular References list and select each address. Check for formulas on other sheets, and make sure that the cell you edited is actually the one identified by the menu.

Also consider whether iterative calculation is enabled. With iteration on, Excel may calculate an intentional circular model rather than presenting it as a simple error, so a numeric result is not proof that the workbook has no circular dependencies. Conversely, a blank-looking cell is not proof that a loop is harmless: formulas that return an empty string or depend on changing inputs can still participate in a circular chain. Review the formulas and the workbook’s calculation design, not just what is currently visible in the cells.

Frequently Asked Questions

Why can’t I see Circular References in the Error Checking menu?
If the option is absent, Excel has not identified a circular reference in the workbook under its current calculation state. Confirm that you are checking the intended workbook and try recalculating. If you are using Excel for the web or a different platform, open the file in the desktop version to follow the Windows navigation described above.

Does Excel show every cell in a circular reference?
The menu lists cell addresses Excel identifies as involved, but it does not map the full chain for you. Follow each formula’s references, including references to other worksheets, to understand how the loop closes. Check the menu again after fixing a cycle because other loops may remain.

Can a circular reference be intentional?
Yes. Some models are deliberately designed to use iterative calculation, which repeats calculations under limits set in Excel. That is a modeling choice, not a general fix for an error. Use it only when the dependency and the expected calculation behavior are understood.

Will turning on iterative calculation fix the formula?
Not necessarily. It allows Excel to calculate circular formulas repeatedly, but it does not correct a wrong reference or guarantee a meaningful answer. For an accidental loop, fix the formula logic instead.

How do I find a circular reference that crosses worksheets?
Select a listed cell from Formulas > Error Checking > Circular References, inspect its formula, and follow its referenced cells across the sheet tabs until the chain returns to a cell already visited. Formula auditing arrows can help show nearby dependencies, but you may need to trace several steps manually.

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.