Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Michigan, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    locate or remove a link (Excel 97)

    I am working on an Excel 97 workbook that is quite large and has 7 interlinked sheets in it. Someone modified the workbook and whatever they did has created a link to another workbook. This link is causing some major problems and we need to get rid of it. Can anyone tell me how I can either locate the cell where the link is originating or just remove the link?

  2. #2
    Star Lounger
    Join Date
    Mar 2001
    Location
    Michigan, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: locate or remove a link (Excel 97)

    I wanted to let you know that I found a way to locate and remove the link. I downloaded a utility called "FindLink.zip". It works great.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: locate or remove a link (Excel 97)

    OK. Was about to refer you to <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=103187>this</A> thread, and it's predecessors. Also, to reset links from the wrong File to the correct File (and retain the link(s)), use Edit, Links, Change Source.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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