ShowDetails Method
Expands the details cells for the specified object. If the specified object is a PivotData object, all detail cells are expanded. If the specified object is a PivotRowMember object, then all details cells in that row are expanded. If the specified object is a PivotColumnMember object, then all details cells in that column are expanded.
expression.ShowDetails
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example expands all of the detail cells in PivotTable1.
PivotTable1.ActiveData.ShowDetails