Expanded Property

See Also                  Applies To

PivotCell object: True if the detail grid is being displayed for the specified cell. If this property is set to False, the detail grid is not displayed, and aggregates are displayed if they are available. Read/write Boolean.

PivotMember object: True if child members or details are being displayed for the specified member; False if child members or details are collapsed. Read/write Boolean.

PivotField object: Returns or sets the expanded state of all the members of the specified field at the same time. Setting the Expanded property for the field immediately sets the Expanded property for all the members associated with the field. Setting the Expanded property for a single member of the field does not affect the Expanded property for the field itself.