AllowMultiFilter Property

Microsoft Office Web Components Object Model

AllowMultiFilter Property

       

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