Information
This policy setting controls whether Excel prompts users to update automatic links, or whether the updates occur in the background with no prompt.
The recommended state for this setting is: Enabled
When users open documents, Excel automatically updates any links to external content, such as graphics, Excel worksheets, and PowerPoint slides. If Excel is configured to automatically update links when documents are open, document content can change without the user's knowledge, which could put important information at risk.
Solution
To establish the recommended state via configuration profiles, set the following Settings Catalog path to Enabled :
Microsoft Excel 2016\Excel Options\Advanced\Ask to Update Automatic Links
Impact:
Users who work with Excel documents that contain external content will not be able to automatically update that content.