Circular Arguments

Kevin OHara 0 Reputation points
2026-08-08T14:55:57.5066667+00:00

How to find circular arguments within a spreadsheet?

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

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-08-08T14:56:11.7066667+00:00

    A circular reference happens when a formula refers to its own cell, either directly or indirectly.

    To find circular references in Excel:

    1. Select the Formulas tab.
    2. Select the arrow next to Error Checking.
    3. Point to Circular References.
    4. Excel shows the cells involved. Select a listed cell to jump directly to it.
    5. Review the formula in that cell.
    6. Repeat for the next listed cell until the status bar no longer shows Circular References.

    Useful checks:

    • If the circular reference is on the active worksheet, the status bar in the lower-left corner shows Circular References and a cell address.
    • If circular references exist on other worksheets but not the active one, the status bar shows only Circular References without a cell address.
    • Moving through each sheet tab can help identify which sheet contains the circular reference.
    • To inspect related cells, use Formulas > Trace Precedents or Trace Dependents.

    If the formula was just entered, start by checking whether it refers to its own cell directly, such as a formula in A3 that includes A3. Also check for indirect references, where one formula points to another cell that eventually points back to the original cell.

    References:

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

    Was this answer helpful?

  2. Kai-H 26,135 Reputation points Microsoft External Staff Moderator
    2026-08-11T08:27:33.0266667+00:00

    Hi, Kevin OHara

    Another practical way is to use Evaluate Formula, which lets you follow a calculation one step at a time:

    Select a cell that contains a suspicious formula.

    On the Formulas tab, select Evaluate Formula.

    Select Evaluate repeatedly and watch which cell references are substituted.

    If the calculation eventually returns to the starting cell, you have found the loop.

    For a large or complicated workbook, you can also use the Spreadsheet Inquire add-in. Select File > Options > Add-ins, choose COM Add-ins, and enable Inquire. Then open the Inquire tab and select Workbook Analysis. The report lists formulas, errors, warnings, and their cell locations, which can make hidden formula problems easier to isolate. Spreadsheet Inquire is available only in supported editions of Excel for Windows, including Microsoft 365 Apps for enterprise and equivalent editions.

    It is also recommended that you check whether iterative calculation is enabled under File > Options > Formulas. If it is enabled unintentionally, Excel may continue calculating a circular formula instead of making the problem obvious. Turn it off temporarily, recalculate the workbook, and check which formulas produce a warning or unexpected zero. Thank you for your patience in reading, I hope this information has been helpful to you. 

    If the answer is helpful, please click "Yes" and kindly upvote it. If you have extra questions about this answer, please click "Comment."    

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    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.