Expanded Element (Microsoft Excel)

Specifies whether the field members are expanded by default, or whether a leaf member was expanded.

Contained In

LeafColumnMember, LeafRowMember, PivotField, PLPivotField

Remarks

If <x:Expanded/> is specified for a leaf member, the member was expanded.

For a PivotTable field, if <x:Expanded/> is specified, the field members are expanded by default. For inner field members, the CellsExpanded and CellsNotExpanded elements specify whether those members are expanded by default.