FileValidationPivot Property
Collapse the table of content
Expand the table of content

Application.FileValidationPivot Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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.

© 2016 Microsoft