Forum Discussion

JoseP1504's avatar
JoseP1504
Copper Contributor
Mar 03, 2023
Solved

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.

Resources