Finding a Linked Cell
 

Hi! Everytime I open up a certain workbook, it asks me if
I want to update the links when it shouldn't have any. I
was wondering if there is a way to find which cell in
which tab has the rogue link? VBE or some other way is
fine.

Thanks!!

Finding a Linked Cell
 

Since links are always contain brackets, try doing a find for the "[". When
you do the find, select the option that searches the entire workbook.

--
Michael J. Malinsky


"michael" wrote in message
...
Hi! Everytime I open up a certain workbook, it asks me if
I want to update the links when it shouldn't have any. I
was wondering if there is a way to find which cell in
which tab has the rogue link? VBE or some other way is
fine.

Thanks!!

Finding a Linked Cell
 

Hi michael,

why don't you try Bill Manvill's "Findlink"

http://www.bmsltd.co.uk/MVP/Default.htm

Wolf

-----Original Message-----
Hi! Everytime I open up a certain workbook, it asks me if
I want to update the links when it shouldn't have any. I
was wondering if there is a way to find which cell in
which tab has the rogue link? VBE or some other way is
fine.

Thanks!!
.