+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

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

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

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

    Perhaps this link could be of interest?

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

    Alf

  3. #3
    Registered User
    Join Date
    01-22-2014
    Location
    Poole
    MS-Off Ver
    Excel 2010
    Posts
    6

    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

Bookmarks

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