Share via

AllowMultiFilter Property

  • Article

Returns or sets whether or not the user can select multiple items when the specified field set is in the filter area of a PivotTable list. The default value is True. Read/write Boolean.

expression.AllowMultiFilter

*expression   * Required. An expression that returns a PivotFieldSet object.

Remarks

Set this property to False to emulate the behavior of a field set in the filter area of the Microsoft Office 2000 PivotTable Component.

Example

The following example disables the selection of multiple items in the Merchant field when it is in the filter area of PivotTable1.

PivotTable1.ActiveView.FieldSets("Merchant").AllowMultiFilter = False

Applies to | PivotFieldSet Object