AllowMultiFilter Property

Microsoft Office Web Components Visual Basic

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