PivotItem.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.

TheDrillTo(String) method supports drilling to a specified PivotField from a PivotItem.

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

public void DrillTo (string Field);

Public Sub DrillTo (Field As String)

Parameters

Field: String

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.

Applies to