Skip to content

Latest commit

 

History

History
45 lines (25 loc) · 1.58 KB

Excel.PivotItem.ShowDetail.md

File metadata and controls

45 lines (25 loc) · 1.58 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotItem.ShowDetail property (Excel)
vbaxl10.chm246082
vbaxl10.chm246082
Excel.PivotItem.ShowDetail
d79e3f27-ff7a-9bf2-313d-e1add3e386a7
05/07/2019
medium

PivotItem.ShowDetail property (Excel)

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.

[!includeSupport and feedback]