Share via

Circular reference cannot be listed in Excel - additional insight

Anonymous
2022-08-22T16:06:51+00:00

Just to add to this community forum, I had the same problem in Excel and found out that the circular reference was on a hidden tab.

So I just saved a copy of the file with all formulas converted to values, and deleted all the hidden tabs. The circular error disappeared.

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 No comments

1 answer

Sort by: Most helpful
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2022-08-22T16:57:07+00:00

    👍 Great insight!!!

    Was this answer helpful?

    0 comments No comments