| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlLocationInTable enumeration (Excel) |
|
85718a67-04ed-9026-1777-85cb4de81886 |
06/08/2017 |
medium |
Specifies the part of the PivotTable report that contains the upper-left corner of a range.
| Name | Value | Description |
|---|---|---|
| xlColumnHeader | -4110 | Column header |
| xlColumnItem | 5 | Column item |
| xlDataHeader | 3 | Data header |
| xlDataItem | 7 | Data item |
| xlPageHeader | 2 | Page header |
| xlPageItem | 6 | Page item |
| xlRowHeader | -4153 | Row header |
| xlRowItem | 4 | Row item |
| xlTableBody | 8 | Table body |
[!includeSupport and feedback]