ShowDetails Method

  • Article

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

Applies to | PivotAxisMember Object | PivotColumnMember Object | PivotData Object | PivotPageMember Object | PivotRowMember Object

See Also | HideDetails Method