Finding a Circular Reference

[Mark T]

How would I go about finding the cells involved in a
circular reference, in a spreadsheet that has LOTS of
formulas, when Excel is giving me the error
message "There is a circular reference in an open
workbook, but the references that cause it can not be
listed for you."?

 

[Ken Macksey]

Hi

Go here and download findcirc.zip.

http://www.bmsltd.co.uk/Excel/Default.htm

HTH

Ken

 

[Mark T]

Thanks very much. Unfortunately this site is
returning "Page Cannot be displayed" errors on some of
the frames, incuding the page thathas this download. I've
sent them an email to get it corrected. In the mean time,
is there any other alternative?