cicular reference

[brian thompson3001 via OfficeKB.com]

Hi

Can anyone let me know how to delete a circular reference. I have tried to
look for the offending cells using the trace arrows but cannot see it. i
would like to clear any cicular ref. in the sheet, therby stopping the
warning boxx.
Is this possible without identifing the particular cell?

regards

 

[Alan]

If you clear all the warnings and pop up boxes, the status bar will tell you
where the circular reference is, eg Circular A1
Regards,
Alan.