Policy

OLAP PivotTable User Defined Function (UDF) security setting

Microsoft Office 5532.1000

Back to categoryOpen picker

Policy overview

Key metadata and intent for this policy.

ClassUser
CategoryMicrosoft Excel 2016 > Miscellaneous
Supported onWindows7

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.

Internal name
L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting
Policy ID
dc31ca6c5d1c
Elements
1

Registry values

How enabled and disabled states update the registry.

No explicit registry values are set for enabled or disabled states.

Policy elements

Inputs and configuration options exposed by this policy.

ElementTypeRegistry mappingConstraints & behavior
OLAP PivotTable User Defined Function (UDF) security setting
ID L_olappivottableuserdefinedfunctionudfsecuritysetting171
enum
HKCU\software\policies\microsoft\office\16.0\excel\options\olapudfsecurity
Type REG_DWORD
Options: Allow ALL UDFs (1), Allow safe UDFs only (2), Allow NO UDFs (3)

Other policies in this category

Explore related policies at the same level.