removing reference to other workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Pradyumna said:
hi

i have a excel wookbook which contains references to other workbook.
Click to expand...
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.
 
Back
Top