en-US office user

Perform file validation on pivot caches

Verified with Microsoft 365/Office 5568.1000 — updated on September 4, 2026 Supported on: At least Windows Server 2008 R2 or Windows 7

Microsoft 365/Office 5568.1000

Path in the GPO console

User Configuration\Administrative Templates\Microsoft Excel 2016\Excel Options\Security

Registry

HKCU software\policies\microsoft\office\16.0\excel\security\filevalidation

Options

pivotoptions enum
  • 0 No file validation
  • 1 Web and email sources default
  • 2 Always perform validation

Description

This policy key configures whether or not pivot caches should go through file validation and get scanned for security problems when documents in Excel 97-2003 format are opened. If you enable this policy setting, you may select one of these options: - No file validation: Never perform file validation on pivot caches for all Excel files (not recommended). - Web and email sources: Perform file validation on pivot caches for documents that come from the web and email, in addition to all documents that trigger pivot caches on load (default). - Always perform validation: Always perform file validation on pivot caches for all Excel files. This setting can be overridden by the Object Model property Application.FileValidationPivot. If you disable or do not configure this policy setting, the "Web and email source" setting will apply.

Export Builder

BETA

Configure the state, scope and options, then generate .reg, PowerShell, Intune and SCCM outputs — or add the setting to a multi-setting collection.

These exports write the registry — this is not a managed GPO. ⓘ

.reg file

Windows Registry Editor Version 5.00

; Exported from gporais.com
; Policy: Perform file validation on pivot caches
; State: Enabled
; Supported on: At least Windows Server 2008 R2 or Windows 7

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\filevalidation]
"pivotoptions"=dword:00000001
More formats (PowerShell, Intune, SCCM)

PowerShell

# Exported from gporais.com
# Policy: Perform file validation on pivot caches
# State: Enabled
# Supported on: At least Windows Server 2008 R2 or Windows 7
# Warning: In SYSTEM context (the Intune default), HKCU targets the SYSTEM profile. Run this script using the logged-on credentials.

$path = 'HKCU:\software\policies\microsoft\office\16.0\excel\security\filevalidation'
New-Item -Path $path -Force | Out-Null
Set-ItemProperty -Path $path -Name 'pivotoptions' -Value 1 -Type DWord

Building a multi-setting collection? Add this setting and generate combined .reg / PowerShell / GPO scripts.

Open the Builder

Embed this policy on your site

What to embed
Theme

Adds one script line: the theme follows your site’s appearance and the height fits the content. If your site blocks scripts, the embed follows the visitor’s system theme.

Preview