Workbook.UpdateLink method (Excel)

Updates a Microsoft Excel, DDE, or OLE link (or links).

Syntax

expression.UpdateLink (Name, Type)

expression A variable that represents a Workbook object.

Name	Required/Optional	Data type	Description
Name	Optional	Variant	The name of the Microsoft Excel or DDE/OLE link to be updated, as returned from the LinkSources method.
Type	Optional	Variant	One of the constants of XlLinkType specifying the type of link.

When the UpdateLink method is called without any parameters, Excel defaults to updating all worksheet links.

This example updates all links in the active workbook.

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources