Export (0) Print
Expand All

ShowDetails Method

Office 2003

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
			
		




Show:
© 2014 Microsoft