Calculation Issues

Find and Fix Circular References in Excel for Mac

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

Question details

Find and correct direct or indirect circular references in an Excel workbook.

Find and Fix Circular References in Excel for Mac
Product
Microsoft Excel 2016 for Mac
Device & OS
Mac
Scenario
A user needs to identify formulas that refer back to their own cells and correct any unintended calculation loops.
Observed behavior
Excel reports a circular reference when a formula refers to its own cell directly or through other formulas.
Before you start

Open the affected workbook in Excel 2016 for Mac and check whether the circular reference is intentional. Some models use iterative calculation on purpose, so review the formula's intended result before changing it.

Solution 1Recommended

Use Error Checking to Find and Correct Circular References

Use Excel's circular reference list to locate affected cells and remove unintended formula loops.

1
Open the circular reference list

In the workbook, select Formulas > Error Checking > Circular References.

2
Inspect a listed cell

Select a cell from the list, then review its formula in the formula bar. Check whether it refers to its own cell directly, such as =A1+1 in cell A1.

3
Trace indirect references

If the formula does not refer to itself directly, select its referenced cells and inspect their formulas for a chain that leads back to the original cell.

4
Correct the formula

Edit the formula in the formula bar to use the intended cells without referring back to itself, then press Return.

5
Check for remaining loops

Return to Formulas > Error Checking > Circular References and repeat for any remaining listed cells. Check the status bar as well for a circular reference message.

Use Error Checking to Find and Correct Circular References
Intentional circular references: If the workbook relies on iterative calculation, changing a circular formula may alter the model's results. Confirm its purpose before editing it.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheet to review and edit formulas as you move between office suites.

Review and edit spreadsheet formulas in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX filesFamiliar interface makes it easier to move from Microsoft OfficeFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

What is a circular reference in Excel?

A circular reference occurs when a formula refers to its own cell, either directly or through a chain of other formulas. For example, =A1+1 entered in A1 refers directly to itself.

Where can I find circular references in Excel 2016 for Mac?

Open the workbook and select Formulas > Error Checking > Circular References. Select a listed cell to inspect its formula.

How do I fix an indirect circular reference?

Start with a cell listed under Formulas > Error Checking > Circular References. Inspect its referenced cells and their formulas until you find the link back to the original cell, then change the unintended reference.

Should I remove every circular reference?

Not necessarily. Some workbooks intentionally use iterative calculation. Check the purpose of the formula before changing it; remove the loop if it is unintended.