Forum Discussion
JoseP1504
Mar 03, 2023Copper Contributor
Circular references in formulas.
(Excel 2016) - Receive error every time I open a specific worksheet:
"There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly.
Try removing or changing these references, or moving the formulas to different cells."
My question is not how to fix them, my question is how to actually find the formula that is causing this error? There are many formulas in this worksheet, and it would be nice if it was somehow highlighted, or there was a button to see which is causing this issue.
- Found the answer, not sure why it didn't showed up when I first searched for it on your site.
The screenshots helped a lot.
Thank you Joe User
https://techcommunity.microsoft.com/t5/excel/circular-reference-when-opening/m-p/3622888
1 Reply
Sort By
- JoseP1504Copper ContributorFound the answer, not sure why it didn't showed up when I first searched for it on your site.
The screenshots helped a lot.
Thank you Joe User
https://techcommunity.microsoft.com/t5/excel/circular-reference-when-opening/m-p/3622888