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.

Remarks

| XlUpdateLinks can be one of these XlUpdateLinks constants.| | xlUpdateLinksAlways Embedded OLE links are always updated for the specified workbook.| | xlUpdateLinksNever Embedded OLE links are never updated for the specified workbook.| | xlUpdateLinksUserSetting Embedded OLE links are updated according to the user's settings for the specified workbook.|

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

See also

Workbook Object