_Application.FileValidationPivot Property
Gets or sets how Microsoft Excel will validate the contents of the data caches for PivotTable reports.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property FileValidationPivot As XlFileValidationPivotMode
Get
Set
'Usage
Dim instance As _Application
Dim value As XlFileValidationPivotMode
value = instance.FileValidationPivot
instance.FileValidationPivot = value
XlFileValidationPivotMode FileValidationPivot { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlFileValidationPivotMode
A XlFileValidationPivotMode object.
Remarks
Read/write.
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.