View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default 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