AllowMultiFilter Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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