EnableDrilldown Property

Applies To

PivotTable object.

Description

True if drilldown is enabled. The default value is True. Read/write Boolean.

Remarks

Setting this property for a PivotTable sets it for all fields in that PivotTable.

Example

This example disables drilldown for all fields in the PivotTable.

Worksheets(1).PivotTables("Pivot1").EnableDrilldown = False