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