| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotField.DrillTo method (Excel) |
vbaxl10.chm240138 |
|
|
a00fe83a-136d-45a3-d3aa-f7ea4d434001 |
05/04/2019 |
medium |
The DrillTo method supports drilling to a specified PivotField from another PivotField.
expression.DrillTo (PivotFieldName)
expression A variable that represents a PivotField object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| PivotFieldName | Required | String | The name of the PivotField to drill to. |
This operation can only be performed on fields that are actually on the PivotTable. Therefore, either a hierarchy containing the requested PivotField has to be in rows or columns of the PivotTable, or the attribute/relational field has to be in rows or columns of the PivotTable placed next to at least one other attribute/relational field. Also, the field being drilled to has to be in the same hierarchy or attribute chain. If these conditions are not met, a run-time error occurs.
[!includeSupport and feedback]