_Application.FileValidationPivot Property
Definition
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 XlFileValidationPivotModeProperty 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.