Find and Fix Circular References in Excel for Mac
Question details
Find and correct direct or indirect circular references in an Excel workbook.

- 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.
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.
Use Error Checking to Find and Correct Circular References
Use Excel's circular reference list to locate affected cells and remove unintended formula loops.
In the workbook, select Formulas > Error Checking > Circular References.
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.
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.
Edit the formula in the formula bar to use the intended cells without referring back to itself, then press Return.
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.

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.

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.




