Share via


PivotItem.DrilledDown Property

True if the flag for the specified PivotTable field or PivotTable item is set to "drilled" (expanded, or visible). Read/write Boolean.

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

Syntax

'Declaration
Property DrilledDown As Boolean
    Get
    Set
'Usage
Dim instance As PivotItem
Dim value As Boolean

value = instance.DrilledDown

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

Property Value

Type: System.Boolean

Remarks

You can use this property only for OLAP data sources.

You cannot set this property if the field or item is hidden.

See Also

Reference

PivotItem Interface

PivotItem Members

Microsoft.Office.Interop.Excel Namespace