Excel.Workbook.UpdateLinks.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.UpdateLinks property (Excel)	vbaxl10.chm199197	vbaxl10.chm199197	Excel.Workbook.UpdateLinks	c8d374d7-0b32-eb32-fa29-ab496d6786e7	05/29/2019	medium

Workbook.UpdateLinks property (Excel)

Returns or sets an XlUpdateLink constant indicating a workbook's setting for updating embedded OLE links. Read/write.

Syntax

expression.UpdateLinks

expression A variable that represents a Workbook object.

Example

In this example, Microsoft Excel determines the setting for updating links and notifies the user.

Sub UseUpdateLinks() 
 
 Dim wkbOne As Workbook 
 
 Set wkbOne = Application.Workbooks(1) 
 
 Select Case wkbOne.UpdateLinks 
 Case xlUpdateLinksAlways 
 MsgBox "Links will always be updated " & _ 
 "for the specified workbook." 
 Case xlUpdateLinksNever 
 MsgBox "Links will never be updated " & _ 
 "for the specified workbook." 
 Case xlUpdateLinksUserSetting 
 MsgBox "Links will update according " & _ 
 "to user settting for the specified workbook." 
 End Select 
 
End Sub

[!includeSupport and feedback]