PivotItem.ShowDetail Property
| Excel Developer Reference |
True if the outline is expanded for the specified range (so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline. Read/write Variant. For the PivotItem object (or the Range object if the range is in a PivotTable report), this property is set to True if the item is showing detail.
Syntax
expression.ShowDetail
expression A variable that represents a PivotItem object.
Remarks
This property isn’t available for OLAP data sources.
If the specified range isn’t in a PivotTable report, the following statements are true:
- The range must be in a single summary row or column.
- This property returns False if any of the children of the row or column are hidden.
- Setting this property to True is equivalent to unhiding all the children of the summary row or column.
- Setting this property to False is equivalent to hiding all the children of the summary row or column.
If the specified range is in a PivotTable report, it’s possible to set this property for more than one cell at a time if the range is contiguous. This property can be returned only if the range is a single cell.
See Also