ExpandMembers Property
Returns or sets a PivotTableExpandEnum constant that represents whether or not fields and their members are expanded when a field is added to a PivotTable list. Read/write.
| PivotTableExpandEnum can be one of these PivotTableExpandEnum constants. |
| plExpandAlways Fields and their members are always expanded when added to a PivotTable list. This setting does not prevent the user from collapsing the field once it has been added to the PivotTable list. |
| plExpandAutomatic default For relational data sources, fields and their members are expanded. For multidimensional data sources, fields and their members are not expanded. |
| plExpandNever Fields and their members are never expanded when added to a PivotTable list. This setting does not prevent the user from expanding the field once it has been added to the PivotTable list. |
expression.ExpandMembers
expression Required. An expression that returns a PivotView object.
Example
This example sets PivotTable1 so that fields are never expanded when they are added to the PivotTable list.
Sub NeverExpand()
Dim pvtView
Dim ptConstants
Set ptConstants = PivotTable1.Constants
' Set a variable to the active view.
Set pvtView = PivotTable1.ActiveView
' Always expand fields when they are added
' to a PivotTable list.
pvtView.ExpandMembers = ptConstants.plExpandNever
' Always expand fields when they are added
' to the detail area PivotTable list.
pvtView.ExpandDetails = ptConstants.plExpandNever
End Sub