Forum Discussion

Roger1949's avatar
Roger1949
Copper Contributor
Mar 29, 2020

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

Resources