XlFileValidationPivotMode Enum

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Specifies how to validate the data caches for PivotTable reports.

public enum class XlFileValidationPivotMode

public enum XlFileValidationPivotMode

Public Enum XlFileValidationPivotMode

Inheritance

Enum

XlFileValidationPivotMode

Fields

Name	Value	Description
xlFileValidationPivotDefault	0	Validate the contents of data caches as specified by the PivotOptions registry setting (default).
xlFileValidationPivotRun	1	Validate the contents of all data caches regardless of the registry setting.
xlFileValidationPivotSkip	2	Do not validate the contents of data caches.

Remarks

This enumeration is used to specify the setting of the FileValidationPivot property of the _Application object.

The effect of the xlFileValidationPivotDefault setting is controlled by the PivotOptions registry value, which is set in the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\FileValidation. The PivotOptions value is a DWORD value that can be set as listed in the following table.

0	Never validate PivotTable report data caches. (Not recommended)
1	Validate PivotTable report data caches in the following cases (Default setting):The file was opened from the Internet.The file is an e-mail attachment.The file was opened by using the Open in Protected View command of the Open dialog box.The file was opened from a known unsafe location where Internet content is cached locally, or from a user-defined untrusted location. The data cache is parsed on load when the file is opened.
2	Validate all PivotTable report data caches.