NamedRange::PivotItem Property
Gets a PivotItem that represents the PivotTable item containing the upper left corner of the NamedRange control.
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Property Value
Type: Microsoft.Office.Interop.Excel::PivotItem^A PivotItem that represents the PivotTable item containing the upper left corner of the NamedRange control.
The following code example creates a PivotTable report and a NamedRange inside the area of the PivotTable report. It then uses the PivotTable, LocationInTable, PivotCell, PivotItem, and PivotField properties to display information about the placement of the NamedRange within the PivotTable report. The example also uses the Group method to perform numeric grouping based on the first value in the field.
This example is for a document-level customization.
Show: