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.
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.
This example disables detail viewing for the PivotTable list.
PivotTable1.AllowDetails = False