Policy
OLAP PivotTable User Defined Function (UDF) security setting
Microsoft Office
Policy overview
Key metadata and intent for this policy.
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.
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.
| Scope | Element | Type | Registry mapping | Constraints & behavior | Copy |
|---|---|---|---|---|---|
| User | OLAP PivotTable User Defined Function (UDF) security setting ID L_olappivottableuserdefinedfunctionudfsecuritysetting171 | enum | Path software\policies\microsoft\office\16.0\excel\options Value name olapudfsecurity Type REG_DWORD | Options: Allow ALL UDFs (1), Allow safe UDFs only (2), Allow NO UDFs (3) |