XlFileValidationPivotMode Enum
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.
Specifies how to validate the data caches for PivotTable reports.
public enum class XlFileValidationPivotModepublic enum XlFileValidationPivotModePublic Enum XlFileValidationPivotMode- Inheritance
-
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. |