Expanded Property
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 but aggregates are displayed if they are available. Read/write Boolean.
PivotAxisMember 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. Read/write Boolean.
expression.Expanded
expression Required. An expression that returns one of the objects in the Applies To list.