PivotTable.EnableDrilldown (Excel)

True if drilldown is enabled. The default value is True.

Setting this property for a PivotTable report sets it for all fields in that report. For OLAP data sources, the value is always True.

ActiveCell.PivotTable.EnableDrilldown = True