Forum Discussion
Help with Circular Reference Error
LBrock wrote: `this system won't let me post the file link from my OneDrive here``
I think that depends on how many posts you have so far. A work-around: edit the beginning of the URL so it does not look like a URL. For example, the URL for this thread is:
techcommunity dot microsoft dot com /t5/excel/help-with-circular-reference-error/m-p/3739678#M180483
-----
Have you tried to use Formula > Error Checking > Circular References to track down the culprit.?
Finding circ refs is more art than science, in some cases. It depends on the complexity of the circ refs.
IMHO, do not enable Iterative Calculations just to avoid the circ ref error, unless you purposely designed a system of circ refs (unreliable and ill-advised, IMHO).
That simply masks the problems. Your formulas probably will not work as intended, anyway.