_Application.FileValidationPivot Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

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.

Applies to