This documentation is archived and is not being maintained.

Workbook.BreakLink Method

Office 2007
Converts formulas linked to other Microsoft Excel sources or OLE sources to values.


expression.BreakLink(Name, Type)

expression   A variable that represents a Workbook object.


NameRequired/OptionalData TypeDescription
NameRequiredStringThe name of the link.
TypeRequiredXlLinkTypeThe type of link.


In this example, Microsoft Excel converts the first link (an Excel link type) in the active workbook.

Bb209716.vs_note(en-us,office.12).gif  Note
This example assumes at least one formula exists in the active workbook that links to another Excel source.
Visual Basic for Applications
Sub UseBreakLink()

    Dim astrLinks As Variant

    ' Define variable as an Excel link type.
    astrLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks)

    ' Break the first link in the active workbook.
    ActiveWorkbook.BreakLink _
        Name:=astrLinks(1), _

End Sub