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

--
bnt

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1

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.
"brian thompson3001 via OfficeKB.com" <u15682@uwe wrote in message
news:6317acacbe382@uwe...
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

--
bnt

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1