Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Circular references in formulas.

Copper 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 (Copper 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
1 best response

Accepted Solutions
best response confirmed by JoseP1504 (Copper 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

View solution in original post