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

XlFileValidationPivotMode

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.