AskToUpdateLinks Property [Excel 2003 VBA Language Reference]

True if Microsoft Excel asks the user to update links when opening files with links. False if links are automatically updated with no dialog box. Read/write Boolean.

Example

This example sets Microsoft Excel to ask the user to update links whenever a file that contains links is opened.

Application.AskToUpdateLinks = True

Applies to | Application Object