Share via

HideDetails Method

  • Article

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.

Example

This example hides all of the detail cells in PivotTable1.

PivotTable1.ActiveData.HideDetails

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

See Also | ShowDetails Method