Completely remove/delete all the external links (Break Links)

**SunOffice** · 11-27-2013, 12:25 AM

Hi All,

I want to know how can I completely remove all the external links from a workbook. In Excel 2010 and 2013, Menu bar >> Data tab >> Edit Links, here I can see "Break Links" option to disconnect external links/files, and this method can also be done by VBA program:

Removing external links in Excel:

Please Login or Register  to view this content.

Now what I am actually looking at is... something like this - XL: Delete Links Wizard Available - http://support.microsoft.com/kb/188449
I have checked this add-in tool, but it does not work for "*.xlsx" and ".xlsm" files.

Break Links method only disconnect from the links, and I also want to remove the displayed broken links, so the "Edit Links" window/information box should be blank.

Please help me!

Thanks & Regards,
SunOffice

**Alf** · 11-27-2013, 02:57 PM

Perhaps this link could be of interest?

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

Alf

**jennyc_83** · 01-23-2014, 05:31 AM

I'm having the same problem. I've used the about link but there arent actually any cells in my workbook that are relevent to the link i want to disappear! a "ghost" link! I'll keep an eye on this post to see if you get an answer quicker than i do!