AllowDetails Property

Microsoft Office Web Components Visual Basic

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