Share via

RemoveFieldSet Method

  • Article

Removes a field set from the specified axis.

expression.RemoveFieldSet(FieldSet)

*expression   * An expression that returns a PivotDataAxis , PivotFilterAxis , or PivotGroupAxis object.

FieldSet    Required Variant. Specifies the field set to be removed. Can be a PivotFieldSet object, a field set name, or a field set index number.

Example

This example removes the ShipVia field from the filter axis in PivotTable1.

PivotTable1.ActiveView.FilterAxis.RemoveFieldSet "ShipVia"

Applies to | PivotAxis Object | PivotDataAxis Object | PivotFilterAxis Object | PivotGroupAxis Object

See Also | AddFieldSet Method