xlFileValidationPivotMode

Specifies how to validate the data caches for PivotTable reports.

xlFileValidationPivotDefault
xlFileValidationPivotRun
xlFileValidationPivotSkip

xlFileValidationPivotDefault
xlFileValidationPivotRun
xlFileValidationPivotSkip

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 ??

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