Workbook.UpdateLinks (Excel)

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

Possible 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