OLAP PivotTable User Defined Function (UDF) security setting
- Policy ID
- L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting
- Scope
- User Configuration
- Supported on
- At least Windows Server 2008 R2 or Windows 7
- Source
- Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
- Category
- Microsoft Excel 2016 › Miscellaneous
Description
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.
Options
Registry
UserHKEY_CURRENT_USER
- olapudfsecurityREG_DWORD