+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Forum Contributor
    Join Date
    Excel World
    MS-Off Ver
    Excel 2013, 2019 & O365

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

    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,
    Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it

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

    Perhaps this link could be of interest?



  3. #3
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

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

    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] External links break after the source workbook is closed
    By jankee in forum Excel General
    Replies: 6
    Last Post: 05-21-2013, 09:14 AM
  2. Unable to break links completely
    By Emmeline in forum Word Formatting & General
    Replies: 3
    Last Post: 12-30-2010, 05:43 AM
  3. Break external Links
    By pauluk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2007, 11:11 AM
  4. best way to remove external links
    By Gary Keramidas in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-21-2005, 04:10 AM
  5. [SOLVED] How do I remove external links from Excel 2000 workbook?
    By mlwest in forum Excel General
    Replies: 2
    Last Post: 02-04-2005, 08:06 PM

Tags for this Thread


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1