Results 1 to 6 of 6

Thread: Links (97 sr2)

  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Links (97 sr2)

    I have Excel 97 and have not been able to break links. I noticed that in Excel XP there is a facility to break links.
    Is it possible to break the links within Excel 97

  2. #2
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Blue Springs, Missouri, USA
    Posts
    108
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Links (97 sr2)

    I have found that the easiest way is to just copy and paste the items back as a value. Links are gone then.

    Dennis

    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links (97 sr2)

    Unwanted links can be problematic. To the best of my knowledge, there is no automatic method of breaking links in Excel 97. Microsoft recommends changing the link source to the current workbook, an approach that has worked for me in the past.

    Also Post 30606 contains information about unwanted links and it also contains links (pardon the pun) to two utilities that deal with unwanted links.

    HTH...

  4. #4
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Links (97 sr2)

    Another, less well known utility to list or break links is the one I wrote: "Locate Links".
    It creates a list of all links and provides options to delete them one by one or all at once.
    Very simple to use. It is an Excel 97 (or later) Add-in and comes with instructions on how to install the Add-in.
    If interested, I will Email it. (124KB)
    The attached word document contains the instructions.

    Jim Cone
    San Jose, CA

  5. #5
    New Lounger
    Join Date
    Aug 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links (97 sr2)

    Hi Jim,

    I thank you for your advise and would like to receive your attachment for breaking the Excel Links.

    Regards

    David

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links (97 sr2)

    You might also consider downloading FINDLINK.zip from the Excel MVP page listed below.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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