PivotField.DrillTo(String) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 void DrillTo(System::String ^ Field);

public void DrillTo (string Field);

Public Sub DrillTo (Field As String)

Parameters

Field: String

Required String The name of the PivotField to drill to.

Remarks

This operation can only be performed on fields that are actually on the PivotTable. So 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.

Applies to