Finding external links

[timkunde]

Hi,

in the excel file I am working on (and that I took over from somebody else) there obviously are some connections to other Excel files via a research function.
So, I am being asked each time I open the file, if I want to update those values.
But I don't, because I actually don't need information from external sources anymore and I would like to delete all references.

I flipped through the pages of the file, but I just can't find those references. Can I get Excel to show or to list all external references, so I am able to delete them?

Thanks

Tim

 

[XL-Dennis]

timkunde,

Sounds like ghostlinks...

Bill Manville's utility FindLink (freeware add-in) will propably solve it:

http://www.bmsltd.co.uk/mvp/MVPPage.asp#Top

Kind regards,
Dennis

 

[Bruno_x]

http://www.herber.de/andere/findlink.zip.

(Dennis, you beat me with 3 seconds.. ? )

This message was edited by Bruno on 2002-08-29 05:36

 

[timkunde]

OK, guys! I downloaded the Add-in and extracted it, but I can't find the Add-In as a menu in my excel file.
How do I get it to work?

Do I have to save the Add-In to a certain place?

Thanks

Tim

 

[royUK]

If you have installed the addin correctly you should open your tools menu and select addins. Scroll down the list of addins and make sure the findlink addin is checked

 

[Ekim]

Most, if not all, of your add-ins will be in the Microsoft library directory:

C:Program FilesMicrosoftOfficeLibrary

In Excel, open a workbook, go to the Tools menu, select Add-ins, scroll down until you find the relevant add-in, click its check box to activate it, then OK. If you can't see it listed, click the browse button and locate it (I think if the add-in is in the Library directory it will be automatically listed). Even if listed, you still have to activate it by clicking its checkbox, then OK.

Regards,

Mike
This message was edited by Ekim on 2002-08-29 14:06