Returns or sets the way members are expanded when their data is refreshed. Read/write PivotTableMemberExpandEnum.
Remarks
If this property is set to plMemberExpandAutomatic, the default expanded state of members is determined by the provider type. If the provider is relational or unknown, members are expanded by default. If the provider is multidimensional, members are collapsed by default.
Setting this property immediately sets the Expanded property on all field sets.
Setting the Expanded property for a field or member does not affect the MemberExpand property.