Workbook.UpdateLinks (Excel)

Returns or sets an XlUpdateLink constant indicating a workbook's setting for updating embedded OLE links. Possible return values are 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.

ActiveWorkbook.UpdateLinks = xlUpdateLinksAlways