Workbook.BreakLink (Excel)

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

BreakLink (Name, Type)

Dim strName As String: strName = 
ActiveWorkbook.BreakLink Name:=strName, Type:=xlLinkTypeExcelLinks

Arguments

The following arguments are required:

Name (String) - The name of the link.

Type (XlLinkType) - The type of link.

Possible Values are xlLinkTypeExcelLinks - A link to a Microsoft Excel source, xlLinkTypeOLELinks - A link to an OLE source.