The only way of checking a circular reference is to look at individual
cells to see which references are contained there and follow
backwards.

You should see a message in the status bar at the bottom "Circular
Reference :"
and a cell reference to start off with. If you cannot see it, you need
to tab through your sheets until you do.

Using Tools/Auditing/.... can help with this. Click in a cell and use
Trace Precedents or Trace Dependents.


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=274040