I am new in VBA, but I have a short procedure to break all external links in the currently active workbook.
Is there any option to firstly update all external links and only then break them?
Dim Links As Variant
Dim i As Integer
Links = .LinkSources(xlExcelLinks)
If Not IsEmpty(Links) Then
For i = 1 To UBound(Links)
.BreakLink Links(i), xlLinkTypeExcelLinks
Thanks for the help in advance!