Locate circular reference - cell cannot be listed

[nvu1991]

I have a worksheet that inform me that it has circular references, and excel cannot locate it for me. I could not find the wrong value. This worksheet is complex, and more importantly, too important to have errors in it. Is there a way (VBA or not) for me to locate this circular cell?

"[FONT=&quot]Microsoft 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"


[/FONT]

 

[RasGhul]

Try this to help you resolve it Nvu

http://smallbusiness.chron.com/remove-circular-references-excel-35895.html

 

[nvu1991]

This piece from the article solve it. Thank you.

[h=4]Tip[/h]

• If your worksheet has circular references in it, the last circular reference that you entered will appear at the bottom of the sheet, next to "Ready." If this reference is on another worksheet, the word "Circular Reference" will appear, but the actual cell address will not."

Try this to help you resolve it Nvu

http://smallbusiness.chron.com/remove-circular-references-excel-35895.html