Application.AskToUpdateLinks Property (Excel)
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.
Syntax
expression .AskToUpdateLinks
expression A variable that represents an Application object.
Example
This example sets Microsoft Excel to ask the user to update links whenever a file that contains links is opened.
Application.AskToUpdateLinks = True