Policy

Ask to update automatic links

This policy setting controls whether Excel prompts users to update automatic links, or whether the updates occur in the background with no prompt. If you enable or do not configure this policy setting, Excel will prompt users to update automatic links. In addition, the "Ask to update automatic links" user interface option under File tab | Advanced | General is selected. If you disable this policy setting, Excel updates automatic links without prompting or informing users, which could compromise the integrity of some of the information in the workbook.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Excel Options / Advanced
Policy ID 5996d9a2f776
Internal name L_Asktoupdateautomaticlinks

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\fupdateext_78_1 (enabled) = 0
HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\fupdateext_78_1 (disabled) = 1

Policy notes

This policy setting controls whether Excel prompts users to update automatic links, or whether the updates occur in the background with no prompt. If you enable or do not configure this policy setting, Excel will prompt users to update automatic links. In addition, the "Ask to update automatic links" user interface option under File tab | Advanced | General is selected. If you disable this policy setting, Excel updates automatic links without prompting or informing users, which could compromise the integrity of some of the information in the workbook.

Related policies

Alert before overwriting cellsAllow formatting and labels to track data pointsAlternate startup file locationAutomatically Flash FillAutomatically insert a decimal pointCommentsCursor movement