Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Illinois
    Posts
    135
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Breaking Links between Workbooks (2000 SR-1)

    I copied much data from an existing workbook, to a new one that should be standalone. I set no links. When I open the new book, it says that there are Excel has "automatic links to information in another workbook." I searched the formulae for references to another workbook, and found none.

    1. Is there a way to find what information is supposedly tethered to the original?

    2. How can I break the link(s)?

    Thank you!

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

    Re: Breaking Links between Workbooks (2000 SR-1)

    Download and install Bill Manville's free add-in FindLink from The Excel MVP Page.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Illinois
    Posts
    135
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Breaking Links between Workbooks (2000 SR-1)

    I ran FindLink, and it found one #REF link. I chose the option to delete it. I saved the workbook. Then opened it up. I ran FindLink for #REF and for .XLS, and it found none. Still a message about links to another workbook.

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

    Re: Breaking Links between Workbooks (2000 SR-1)

    Does Edit | Links shed any light on the problem?

  5. #5
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Illinois
    Posts
    135
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Breaking Links between Workbooks (2000 SR-1)

    Yes it did! The problem was not with a link to another file. It was links to a worksheet that didn't exist. I accomplished this by updating a worksheet tab with a TYPO.

Posting Permissions

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