Skip to content

Latest commit

 

History

History
39 lines (23 loc) · 1.24 KB

Excel.PivotItem.DrillTo.md

File metadata and controls

39 lines (23 loc) · 1.24 KB
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotItem.DrillTo method (Excel)
vbaxl10.chm246094
vbaxl10.chm246094
Excel.PivotItem.DrillTo
627806c2-834f-d217-1439-1e17bedd15c0
05/07/2019
medium

PivotItem.DrillTo method (Excel)

The DrillTo method supports drilling to a specified PivotField from a PivotItem.

Syntax

expression.DrillTo (PivotItemName)

expression A variable that represents a PivotItem object.

Parameters

Name Required/Optional Data type Description
PivotItemName Required String The name of the PivotItem to drill to.

Remarks

For OLAP data sources, the PivotField being drilled to has to be in the same hierarchy as the PivotItem being drilled or, if multiple attribute hierarchies are placed next to each other on rows or columns, the PivotField being drilled to has to be one of the attribute hierarchies that are next to each other; no user hierarchies can be placed in between the PivotField of the PivotItem being drilled and the PivotField being drilled to. If these conditions are not met, a run-time error is returned.

[!includeSupport and feedback]