SOLVED

Circular references in formulas.

New Contributor

(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.

1 Reply
best response confirmed by JoseP1504 (New Contributor)
Solution
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