Mar 03 2023 01:44 PM
(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.
Mar 03 2023 01:54 PM
SolutionMar 03 2023 01:54 PM
Solution