SOLVED: How To Remove Links From Excel That No Longer Exist

If, when you open and Excel workbook, you receive an UPDATE LINKS message but the linked source no longer exists, you have a problem.  You SHOULD be able to go to the DATA tab > EDIT LINKS button and choose DELETE LINK on the offender but that often does not work.

After working on this for sometime and doing what I could to avoid downloading utilities to correct the problem, I gave up and downloaded THIS file from THIS site.  To use it:

  1. Open the Excel file with the phantom link(s)
  2. Double click on the FINDLINK.XLA script
  3. In Excel, click the ADD-IN tab
  4. Click on the FIND LINK button
  5. Click DELETE on any of the links you do not want to use

We did not write this script but it does appear to work on even the most current Excel although it says it is for Office 2003.   I just ran this on an Excel .XLSX file in Office 2013 and it worked as expected without any ill effects.

As with all scripts, you must use them at your own risk.  Personally, I would take a copy/backup of the file you are going to work on first in case your experience is not as nice as mine.

Questions or Comments?