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

General Ledger

Active Member
Joined
Dec 31, 2007
Messages
460
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.

Code:
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
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,099,078
Messages
5,466,488
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top