AllowDetails Property

  • Article

Specifies whether the user can expand an inner member of the specified PivotTable list to display detail records. The default value is True. Read/write Boolean.

expression.AllowDetails

expression Required. An expression that returns a PivotTable object.

Remarks

When this property is False, inner members do not display expand indicators, the Expand command is disabled for most aggregates, and double-clicking an aggregate does not display detail data. If this property is False, the user can still view details programmatically.

Example

This example disables detail viewing for the PivotTable list.

PivotTable1.AllowDetails = False

Applies to | PivotTable Object

See Also | AllowDeletingColumns Property | AllowDeletingRows Property | AllowFiltering Property | AllowGrouping Property | AllowInsertingColumns Property | AllowInsertingRows Property | AllowPropertyToolbox Property | AllowSorting Property