Application.FileValidationPivot (Excel)

Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Possible return values are xlFileValidationPivotDefault - Validate the contents of data caches as specified by the PivotOptions registry setting , xlFileValidationPivotRun - Validate the contents of all data caches regardless of the registry setting, xlFileValidationPivotSkip - Do not validate the contents of data caches.

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 that the application is open.

Application.FileValidationPivot = xlFileValidationPivotDefault