_Application.FileValidationPivot property

Office 2013 and later

Gets or sets how Microsoft Excel will validate the contents of the data caches for PivotTable reports.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

XlFileValidationPivotMode FileValidationPivot { get; set; }


Files that contain data caches that do not validate will be opened in a Protected View window. If you set the FileValidationPivot property, that setting will remain in effect for the entire session the application is open.