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