Policy

OLAP PivotTable User Defined Function (UDF) security setting

PivotTable reports can contain OLAP queries with references to User Defined Functions (UDFs). UDFs can be compiled executables, therefore posing a potential security threat. With this setting you can either (1) allow all UDFs in OLAP queries to execute with no IObjectSafety check, (2) allow only UDFs where the developer has used IObjectSafety to mark the UDF as a safe executable, or (3) disable all UDFs from executing in OLAP queries. The effect of setting this key is for Excel to pass the selected value to the OLAP provider.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Miscellaneous
Policy ID dc31ca6c5d1c
Internal name L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\excel\options\olapudfsecurity

Policy notes

PivotTable reports can contain OLAP queries with references to User Defined Functions (UDFs). UDFs can be compiled executables, therefore posing a potential security threat. With this setting you can either (1) allow all UDFs in OLAP queries to execute with no IObjectSafety check, (2) allow only UDFs where the developer has used IObjectSafety to mark the UDF as a safe executable, or (3) disable all UDFs from executing in OLAP queries. The effect of setting this key is for Excel to pass the selected value to the OLAP provider.

Related policies

Block all unmanaged add-insDisable 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-ins