Hides the details cells for the specified object. If the specified object is a PivotData object, all detail cells are hidden. If the specified object is a PivotRowMember object, then all details cells in that row are hidden. If the specified object is a PivotColumnMember object, then all details cells in that column are hidden.
expression.HideDetails
expression Required. An expression that returns one of the objects in the Applies To list.
This example hides all of the detail cells in PivotTable1.
PivotTable1.ActiveData.HideDetails