NoAllowFiltering Element (Microsoft Excel)

Specifies whether the user can modify filters.

Contained In

PivotTable

Remarks

If <x:NoAllowFiltering/> is specified, the following conditions are true:

• The AutoFilter command is disabled.
• The Filter By Selection command is disabled.
• The Move to Filter Area command is disabled.
• The Move to Detail command is disabled if the selection is a field in the filter area.
• All AutoFilter drop-down boxes are read-only. Note that the user can still view these boxes even though they are disabled.
• You can still set filters programmatically.
• Membership in the filter area is fixed; the user cannot drag a field to or from the filter area.