AskToUpdateLinks Property
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