EnableDrilldown Property Example
This example disables drilldown for all fields in the the first PivotTable report on worksheet one/.
Worksheets(1).PivotTables("Pivot1").EnableDrilldown = False