cicular reference
 

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

cicular reference
 

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