| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Worksheet.PivotTables method (Excel) |
vbaxl10.chm175118 |
|
|
b60944cd-827d-15dc-d49e-c739c237de15 |
05/30/2019 |
medium |
Returns an object that represents either a single PivotTable report (a PivotTable object) or a collection of all the PivotTable reports (a PivotTables object) on a worksheet. Read-only.
expression.PivotTables (Index)
expression A variable that represents a Worksheet object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Index | Optional | Variant | The name or number of the report. |
Object
This example sets the Sum of 1994 field in the first PivotTable report on the active sheet to use the SUM function.
ActiveSheet.PivotTables("PivotTable1"). _
PivotFields("Sum of 1994").Function = xlSum[!includeSupport and feedback]