How to break an external link that won't break

Anonymous
2012-01-11T18:42:31+00:00

I have studied all the Excel help available and followed the advice, but I have encountered an external link in an Excel 2010 workbook that simply will not break. No matter how many times I select "Break Link," this zombie is always there. I have tried deleting range names that came from the source file, to no avail. I "break the link" in the destination file, save, close the file, reopen it -- and the link is still there. I have tried adjusting the options every which way, no luck.

How do I absolutely, positively, completely and forever, send this link to Davy Jones's locker?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2012-12-04T08:40:04+00:00

Dear Long_John_Silver

I had a similar issue and in addition to Raju S Das' recommendation, I have also checked the data validations for various fields; this is where I found some zombie links that were not required anymore.

Maybe you can find some in your file too and remove them:

  • Select the cells where you expect the zombie data validation (I could narrow it down to one section on a specific worksheet)
  • In the Data Tools section of the Data ribbon, select Data Validation from the Data Validation dropdown
  • Check if there is any list validation with a reference to a linked file location.

Hope this helps.

Best regards,

Roger

Was this answer helpful?

300+ people found this answer helpful.
0 comments

69 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2016-08-08T14:48:10+00:00

    For me this happened because I wound up with two versions of the same named range (which happens when you paste a named range from one workbook to a copy of the workbook without "pasting values")

    BUT when I checked in the Formulas --> Name Manager, there was only one named range in there, the correct one what was needed for the workbook.  

    To resolve this, we actually had to break the excel file up into its XML components (it was a .xlsx file) and look for the duplication.  Lo and behold it was there.  So we deleted the link reference to the other workbook out of the XML and saved the file.  And the link was finally gone.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-07-27T03:56:54+00:00

    I found another "source" of the link that is not detected by the "Edit Links" menu.

    It is in the Drop-Down box (or other feature in "Form Control").

    This is feature you can find in the ribbon "Developer | Insert | Form Control".

    Once you change or delete the cell reference that links to other workbook, the link would disappear.

    Hope this might helps.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-07-13T04:00:15+00:00

    Obviously this is a software bug in Excel that has been there for years.  I tried all many recommended break link methods per MS Excel info, but wont work at all. I suggest microsoft should seriously fix this bug.

    I found findlink from below works really well. But I dont know how it does it.

    http://www.manville.org.uk/software/default.htm

    Best of luck.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-07-12T23:54:55+00:00

    Raj, If you are still there, thank you so much for the advice. Worked like a charm.

    Was this answer helpful?

    0 comments