Edit

Share via


_Application.FileValidationPivot Property

Definition

Gets or sets how Microsoft Excel will validate the contents of the data caches for PivotTable reports.

public:
 property Microsoft::Office::Interop::Excel::XlFileValidationPivotMode FileValidationPivot { Microsoft::Office::Interop::Excel::XlFileValidationPivotMode get(); void set(Microsoft::Office::Interop::Excel::XlFileValidationPivotMode value); };
public Microsoft.Office.Interop.Excel.XlFileValidationPivotMode FileValidationPivot { get; set; }
Public Property FileValidationPivot As XlFileValidationPivotMode

Property Value

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.

Applies to