+ Reply to Thread
Results 1 to 3 of 3

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

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2013, 2019 & O365
    Posts
    214

    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:
    Sub RemoveLinks()
    ' Code 1 - http://p2p.wrox.com/excel-vba/9625-removing-external-links-excel.html
    Dim Link As Variant
        For Each Link In ActiveWorkbook.LinkSources
            MsgBox Link
            ActiveWorkbook.BreakLink Name:=Link, Type:=xlLinkTypeExcelLinks
            ActiveWorkbook.BreakLink Name:=Link, Type:=xlLinkTypeExcelLinks
        Next
    End Sub
    '----------------------------------------------------------------------------------------
    
    Sub BreakAllLinks()
    ' Code 2 - http://mydailymicrosoft.blogspot.in/2012/06/vba-break-all-external-links-in.html
    Dim arrStrLinks As Variant
        ' Read workbook links to an array.
        arrStrLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks)
        ' Loop through whole array -> all links.
        For i = 1 To UBound(arrStrLinks)
            ActiveWorkbook.BreakLink _
            Name:=arrStrLinks(i), _
            Type:=xlLinkTypeExcelLinks
        Next i
    End Sub
    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,784

    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. [SOLVED] 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. 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