Error Message

Anonymous
2025-02-02T15:03:20+00:00

I need some help in understanding this statement.

I did some tweeking on a spreadsheet and now when I open the spreadsheet I get this error message. How do I find the "circular reference" that trigger this message.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2025-02-02T15:08:41+00:00

    Activate the Formulas tab of the ribbon.

    In the Formula Auditing group, click the drop-down arrow on the right-hand side of the Error Checking button.

    Select Circular References in the drop-down menu.

    Click on the cell reference in the fly-out menu. This will take you to the cell, so that you can investigate its formula.

    Was this answer helpful?

    0 comments