Intune Settings Catalog ViewerIntune Settings
Browse
OIB Lookup
LookupChangelog
MS Baselines
LookupChangelog
ComplianceChangelogMCPAbout

Data sourced from Microsoft Graph API. Not affiliated with Microsoft. By Lewis Barry | Enhanced by Roy Klooster.

Try rmmguard.com · Last updated: November 13, 2026

HomeMicrosoft Excel 2016MiscellaneousOLAP PivotTable User Defined Function (UDF) security setting (User)

OLAP PivotTable User Defined Function (UDF) security setting (User)

Windows

Category: Miscellaneous

WindowsMDM

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 (2)

Disabled(default)
Enabled
./User/Vendor/MSFT/Policy/Config/excel16v2~Policy~L_MicrosoftOfficeExcel~L_miscellaneous168/L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting

Child Settings (1)

OLAP PivotTable User Defined Function (UDF) security setting (User)