Mar 29 2020 07:26 AM
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.
Mar 29 2020 09:57 AM
Apr 04 2020 06:47 AM
No, the excel message said it couldn't identify the source of the error, so no reference was given.
Apr 04 2020 06:54 AM