Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Link Finder (2000)

    With the search engine down, I am forced to ask where I can find the add-in that will enable me to find links in a workbook fast and easy.
    Any help would be greatly appreciated.
    Jeff

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Link Finder (2000)

    Thanks, Hans. Now that I have it downloaded to my hard-drive, when I try and find a link in Excel, it says the macro "FindLink.xla" can't be found!
    Any ideas?

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link Finder (2000)

    In order to use it, you must select Tools | Add-Ins...
    Unless you already copied FindLink.xla to your Addins folder, you must use the 'Browse...' button.
    Navigate to the location where you unzipped the .xla. Select it, and click 'OK'.
    Excel will ask whether you want to copy 'Findlink.xla' to your Addins folder. Click 'Yes'.
    Find/delete links appears in the list of add-ins, and its check box is ticked. Click 'OK'.
    You should then be able to use the new menu item Tools | Find Links.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Link Finder (2000)

    Thanks, Hans. A little rusty this AM!

  5. #5
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link Finder (2000)

    Navigator Utilities has a Link navigator that displays all links in a list box enabling you to jump directly to them or delete them etc. Also allows you to change source file, open or close source files etc. A Multiple Files option allows you to produce a list of all links in a directory (with or without subdirectories) and even perform a batch change of all linked workbooks which i handy for when file are moved to a different location (such as to a new server) and all the links are broken.

    Navigator Utilities also has a Sheet and Named Range Navigator as well as enhanced Find/Replace feature.

    Free download at www.robbo.com.au

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Link Finder (2000)

    Mark,
    I am having trouble adding it as an add-in; could you walk me through it?
    Thanks,
    Jeff

  7. #7
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link Finder (2000)

    Have you used the auto install feature?
    If this doesn't work, try a manual installation. Simply extract the file navigator.xla from the zip file to your c: drive, and then in Excel, choose Tools, Add-ins, click on browse and point to the navigator.xla which you extracted from the zip file. Select the option to copy the add-in to the Excel add-in location (you can then remove the original file). Let me know how you go.

    regards

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link Finder (2000)

    (Edited by HansV to update link to Excel MVP site)

    It's on the Excel MVP Page: FindLink by Bill Manville.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •