Workbook.UpdateLink method (Excel)
Updates a Microsoft Excel, DDE, or OLE link (or links).
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.
VB
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.