Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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
			
		




Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.