Find and Fix a Circular Reference in Excel for iPad
Question details
Find and correct a circular reference in an Excel workbook on an iPad.

- Product
- Microsoft Excel for iPad
- Device & OS
- iPadOS
- Scenario
- A user needs to locate a formula that directly or indirectly refers back to its own cell.
- Observed behavior
- Excel for iPad displays a circular reference warning but has limited formula-auditing tools.
Note any recently edited formulas and the worksheet where the warning appeared. If you have access to Excel on a computer, make sure you can open the same workbook there.
Check Recently Changed Formulas on the iPad
Use this method when you need to find and correct the reference without leaving Excel for iPad.
A circular reference occurs when a formula refers to its own cell, either directly or through a chain of other formulas.
In Excel for iPad, tap a recently edited formula cell and review its formula in the formula bar.
Check whether the formula includes its own cell or a range containing it. Tap referenced cells and inspect their formulas to find any indirect path back to the original cell.
Edit the formula in the formula bar to reference the intended cells instead. For example, replace an unintended =A1+1 in cell A1 with a reference to the correct input cell.
Confirm the edited formula, review any remaining circular reference warnings, and save the workbook.

Locate the Circular Reference in Excel on a Computer
Use desktop formula-auditing tools when manually tracing formulas on the iPad is difficult.
Review and Correct Circular References in WPS Spreadsheets
Open the workbook in WPS Spreadsheets, inspect the formulas involved, and edit unintended self-references manually.
- 1. Open the workbook: Launch WPS Office and open the Excel workbook in WPS Spreadsheets.
- 2. Inspect formulas: Select recently changed formula cells and review each formula in the formula bar for references to its own cell or range.
- 3. Trace and edit: Select referenced cells to check for indirect loops, then edit the affected formula to use the intended inputs.
- 4. Save the workbook: Use Save or Save As to save the corrected workbook, then check the affected calculations.

Frequently Asked Questions
What is a circular reference in Excel?
It is a formula that refers back to its own cell directly or through other formulas. For example, =A1+1 entered in A1 is a direct circular reference.
How can I find the circular reference without a computer?
In Excel for iPad, tap recently changed formula cells and inspect the formula bar. Follow their references, including ranges, until you find a path back to the original cell.
Where is the Circular References command in desktop Excel?
Open the workbook in Excel on a computer and choose Formulas > Error Checking > Circular References. Select a listed cell to inspect its formula.
Does every circular reference need to be removed?
No. Some workbooks use circular references intentionally for iterative calculations. Check the workbook's purpose before changing one.




