Forum Discussion
How to Find and Delete a Link in an Excel
Hi, My Excel Indicates It cannot update a link when I open it. I cant see any link in the Data links, so not sure where to find and delete the link. The message says: We cant connect to "htt...
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