How to Find and Delete a Link in an Excel

AJFBlog 

Another approach is using vba to remove broken links

Sub BreakLinks()
    Dim wb As Workbook
    Set wb = Application.ActiveWorkbook
    If Not IsEmpty(wb.LinkSources(xlExcelLinks)) Then
        For Each link In wb.LinkSources(xlExcelLinks)
            wb.BreakLink link, xlLinkTypeExcelLinks
        Next link
    End If
End Sub

AJFBlog 

Find links (external references) in a workbook

Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist. There is no automatic way to find all external references that are used in a workbook, however, there are several manual methods you can use to find them in this upper Link.

NikolinoDE

Was the answer useful? Mark them as helpful!

This will help all forum participants.