xlPropertyDisplayedIn

Specifies where to display the property.

xlDisplayPropertyInPivotTableDisplays member property in the PivotTable only
This is the default value (1)
xlDisplayPropertyInPivotTableAndTooltipDisplays member property in the tooltip only (3)
xlDisplayPropertyInTooltipDisplays member property in both the tooltip and the PivotTable (2)

xlDisplayPropertyInPivotTable
Displays member property in the PivotTable only
This is the default value (1)
xlDisplayPropertyInPivotTableAndTooltip
Displays member property in the tooltip only (3)
xlDisplayPropertyInTooltip
Displays member property in both the tooltip and the PivotTable (2)

REMARKS
* Added in 2007.

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