Application.FileValidationPivot property (Excel)
Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write.
Syntax
expression.FileValidationPivot
expression A variable that represents an Application object.
Return value
Remarks
Files that contain data caches that don't 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 that the application is open.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.