RemoveFieldSet Method

Microsoft Office Web Components Object Model

RemoveFieldSet Method

       

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"