removing reference to other workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pradyumna - 22 Jul 2004 06:50 GMT

hi

i have a excel wookbook which contains references to other workbook. whenever i open this wookbook it asks me for updating the link to the other workbook. i want to remove these references to other workbook but am not able to figure out which cell is refering to the other workbook. i also have lot of references in the same workbook. i dont want the internal references to be removed.

can anyone help me to accomplish this task. any help is highly appretiated.

thankx in advance.
pradyumna

Reply to this Message

Frank Kabel - 22 Jul 2004 06:56 GMT

Hi
try the following add-in to find/delete links:
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> hi
>
> i have a excel wookbook which contains references to other workbook. whenever i open this wookbook it asks me for updating the link to the

other workbook. i want to remove these references to other workbook but
am not able to figure out which cell is refering to the other workbook.
i also have lot of references in the same workbook. i dont want the
internal references to be removed.

> can anyone help me to accomplish this task. any help is highly appretiated.
>
> thankx in advance.
> pradyumna

Reply to this Message

Pradyumna - 22 Jul 2004 07:18 GMT

hi Frank

Thank you very much. i was able to delete all the links.

regards
Pradyumna

> Hi
> try the following add-in to find/delete links:
[quoted text clipped - 19 lines]
> > thankx in advance.
> > pradyumna

Reply to this Message