Application.FileValidationPivot Property (Excel)
Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write
Version Information
Version Added: Excel 2010
Syntax
expression .FileValidationPivot
expression A variable that represents an Application object.
Return Value
Remarks
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.