XlPropertyDisplayedIn Enumeration

Specifies where to display the property.

Name

Value

Description

xlDisplayPropertyInPivotTable

1

Displays member property in the PivotTable only. This is the default value.

xlDisplayPropertyInPivotTableAndTooltip

3

Displays member property in the tooltip only.

xlDisplayPropertyInTooltip

2

Displays member property in both the tooltip and the PivotTable.