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.

expression .AskToUpdateLinks

expression A variable that represents an Application object.

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

Application.AskToUpdateLinks = True