Break Links often fails. Why and what is a work around?

[General Ledger]

Dear All,

What the heck is wrong with the Break Link tool in Excel 2010 !?!?!

It seems sometimes it works and other times it does not.

I have workbooks with dozens of links to more than one other workbook.

I break links, save, close, open, and repeat. Sometimes I am successful in breaking all links and sometimes not.

I even ran a macro which seems powerless.

Sub BreakLinks()
    Dim Links As Variant
    Dim i As Integer
    With ActiveWorkbook
        Links = .LinkSources(xlExcelLinks)
        If Not IsEmpty(Links) Then
            For i = 1 To UBound(Links)
                .breaklink Links(i), xlLinkTypeExcelLinks
            Next i
        End If
    End With
End Sub

What is the problem?

Is there a work-around?

Thanks,

A Very Frustrated User