Results 1 to 4 of 4
  1. #1
    5 Star Lounger ibe98765's Avatar
    Join Date
    Aug 2001
    Location
    Bay Area, California, USA
    Posts
    968
    Thanks
    19
    Thanked 4 Times in 4 Posts

    Find & remove links (2000 SP1)

    I have a workbook that when it opens wants to update a link to an external spreadsheet. I don't know how this link got created or where it is. How do I find it and get rid of it. I can see the link on the Edit|Links menu item but Excel doesn't let me remove it from here. I also cannot find any way to locate the cell that contains the link.

    Thanks...

  2. #2
    5 Star Lounger ibe98765's Avatar
    Join Date
    Aug 2001
    Location
    Bay Area, California, USA
    Posts
    968
    Thanks
    19
    Thanked 4 Times in 4 Posts

    Re: Find & remove links (2000 SP1)

    Damm. I don't know if this is the accepted way to remove a link but it worked. I selected "change source" from the edit|links menu item and then pointed to the same workbook that was already open. That cleared the link. This is really obtuse and stupid! And I can't find any help in the help file on how to do this.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Find & remove links (2000 SP1)

    Manually you can search for the filename to look for links.

    A place also to look that is often forgotten is under insert - name -define. If you copy/move worksheets, you sometimes will inherit names that are linked to that original worksheet.

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

    Re: Find & remove links (2000 SP1)

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

    You can download Bill Manville's Findlink utility from http://www.bmsltd.ie/mvp. This utility will show you the location and source of all links in a workbook, with the option to delete them.

Posting Permissions

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