Circular arguments

Kevin OHara 0 Reputation points
2026-10-15T17:21:55.4266667+00:00

How can I find a circular argument within an Excel preadsheet? I am using IOS.

Microsoft 365 and Office | Excel | Other | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marcin Policht 110.6K Reputation points MVP Volunteer Moderator
    2026-10-15T19:39:58.0433333+00:00

    On Excel for iOS, the full circular-reference auditing tools available in the desktop version are not provided. If Excel detects a circular reference, it may display a warning, but finding an indirect circular reference can be difficult on the iPhone or iPad.

    A direct circular reference is straightforward. For example, if cell A1 contains:

    =A1+B1

    then A1 refers to itself.

    An indirect circular reference is more difficult because the loop can involve several cells:

    A1 → B1 → C1 → D1 → A1

    For example:

    A1: =B1+C1
B1: =D1*2
D1: =A1/2

    Here, A1 → B1 → D1 → A1 creates the circular reference.

    If you are restricted to iOS, you might want to start with cells whose formulas were recently changed or that produce unexpected results, examine the formula in the formula bar, and follow each referenced cell. Keep following the references until you either reach a cell with no dependency on the original cell or return to the starting cell. If the workbook is large, opening it in Excel on Windows or Mac is much easier because the desktop version can identify circular references and trace the precedent/dependent chain.

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-10-15T17:22:08.02+00:00

    A circular reference happens when a formula refers to itself directly or indirectly.

    On iOS, Excel has limited formula auditing tools, so the practical way to find a circular reference is to open the workbook in Excel for Windows or Mac desktop.

    Steps:

    1. Open the workbook in the desktop Excel app.
    2. Go to Formulas > Error Checking > Circular References.
    3. Select each listed cell address to jump to the problem cell.
    4. Fix the formula so it no longer points back to itself.
    5. If the issue spans multiple cells, use Formulas > Trace Precedents or Trace Dependents.
    6. Repeat until the status bar no longer shows Circular References.

    If Circular References is unavailable:

    1. Select a worksheet cell first.
    2. Try Formulas > Error Checking again.
    3. Use the Excel search box and search for Error Checking or Circular References.

    If the warning continues after editing, another circular reference may still exist on a different worksheet or in another open workbook.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.