removing reference to other workbook

[Guest]

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

 

[Frank Kabel]

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

--
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.

 

[Guest]

hi Frank

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

regards
Pradyumna