Partager via


PivotTable.EnableDrilldown Property

True if drilldown is enabled. The default value is True. Read/write Boolean.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property EnableDrilldown As Boolean
    Get
    Set
'Usage
Dim instance As PivotTable
Dim value As Boolean

value = instance.EnableDrilldown

instance.EnableDrilldown = value
bool EnableDrilldown { get; set; }

Property Value

Type: System.Boolean

Remarks

Setting this property for a PivotTable report sets it for all fields in that report.

For OLAP data sources, the value is always True.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace