ExpandDetails Property
PivotTableExpandEnum
PivotTableExpandEnum can be one of these PivotTableExpandEnum constants. |
plExpandAlways Fields are always expanded when added to the detail area of a PivotTable list. This setting does not prevent the user from collapsing the field once it has been added to the PivotTable list. |
plExpandAutomaticdefault For relational data sources, fields and their members are expanded. For multidimensional data sources, fields and their members are not expanded. |
plExpandNever Fields are never added to the detail area of a PivotTable list. This setting does not prevent the user from expanding the field once it has been added to the PivotTable list. |
expression.ExpandDetails
*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
Applies to | PivotView Object
See Also | ExpandMembers Property | HideDetails Method