Forum Discussion
Roger1949
Mar 29, 2020Copper Contributor
Circular Reference in excel
I am getting the "Excel cannot calculate a formula, there is a circular reference in an open workbook, but the references that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the Undo command." error message. My workbook is 30 pages long and each page contains hundreds of formulas. I didn't get this error message until after I had made multiple changes. Is there any way to identify it, other that checking each formula, which would take days or weeks.
3 Replies
Sort By
- Hello,
You can check the video links below to resolve the circular reference issue
https://m.youtube.com/watch?v=j0nRTcoKrE0&t=229s
https://m.youtube.com/watch?v=TpTZnI53IF8 - TwifooSilver ContributorThe address of the circular reference is indicated at the status bar at the bottom of your screen.
- Roger LundbergCopper Contributor
No, the excel message said it couldn't identify the source of the error, so no reference was given.