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.

Supported on: At least Windows 7

OLAP PivotTable User Defined Function (UDF) security setting


  1. Allow ALL UDFs
    Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\excel\options
    Value Nameolapudfsecurity
    Value TypeREG_DWORD
    Value1
  2. Allow safe UDFs only
    Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\excel\options
    Value Nameolapudfsecurity
    Value TypeREG_DWORD
    Value2
  3. Allow NO UDFs
    Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\excel\options
    Value Nameolapudfsecurity
    Value TypeREG_DWORD
    Value3


excel16.admx

Administrative Templates (Computers)

Administrative Templates (Users)