XlPropertyDisplayedIn Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

Show: