xlFileValidationPivotMode

Specifies how to validate the data caches for PivotTable reports.

xlFileValidationPivotDefaultValidate the contents of data caches as specified by the PivotOptions registry setting (default)
(0)
xlFileValidationPivotRunValidate the contents of all data caches regardless of the registry setting
(1)
xlFileValidationPivotSkipDo 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 ??

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top