xlFileValidationPivotMode

Specifies how to validate the data caches for PivotTable reports.

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

xlFileValidationPivotDefault

Validate the contents of data caches as specified by the PivotOptions registry setting (default)
(0)

xlFileValidationPivotRun

Validate the contents of all data caches regardless of the registry setting
(1)

xlFileValidationPivotSkip

Do not validate the contents of data caches
(2)

REMARKS

* Added in 2010.
* 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.
* xlXMLData (47) this was listed in the MSFT website but is not in the 2003 enumeration ??