Name

workbook.UpdateLinks [= setting]

Synopsis

Changes the way OLE links are updated when the workbook is opened. Possible xlUpdateLink settings are:

xlUpdateLinksAlways

Updates links when the workbook is opened, does not alert the user

xlUpdateLinksNever

Does not update links when the workbook is opened or alert the user

xlUpdateLinksUserSetting

Alerts the user if the workbook contains links when the workbook is opened and asks if those links should be updated (default)

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.