Application.FileValidationPivot Property (Excel)

Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write

Version Added: Excel 2010

expression .FileValidationPivot

expression A variable that represents an Application object.

Return Value

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.

Show: