removing reference to other workbook

P

Pradyumna

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
 
Top