Policy

Block all unmanaged add-ins

This policy setting blocks all add-ins that are not managed by the "List of managed add-ins" policy setting. If you enable this policy setting, and the "List of managed add-ins" policy setting is also enabled, all add-ins are blocked except those that are configured as 1 (always enabled) or 2 (configurable by the user) in the "List of managed add-ins" policy setting. If you disable or do not configure this policy setting, users can enable or disable any add-ins that are not managed by the "List of managed add-ins" policy setting.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Miscellaneous
Policy ID adf534b3ed37
Internal name L_BlockAllUnmanagedAddins

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\excel\resiliency\restricttolist (enabled) = 1
HKCU\software\policies\microsoft\office\16.0\excel\resiliency\restricttolist (disabled) = 0

Policy notes

This policy setting blocks all add-ins that are not managed by the "List of managed add-ins" policy setting. If you enable this policy setting, and the "List of managed add-ins" policy setting is also enabled, all add-ins are blocked except those that are configured as 1 (always enabled) or 2 (configurable by the user) in the "List of managed add-ins" policy setting. If you disable or do not configure this policy setting, users can enable or disable any add-ins that are not managed by the "List of managed add-ins" policy setting.

Related policies

Disable Office Scripts in Excel for Windows DesktopDisable the Office Start screen for ExcelDo not cache network files locallyEnable four-digit year displayGraph gallery pathList of managed add-insOLAP PivotTable User Defined Function (UDF) security setting