Skip to main content
Row

PivotTableCollection.Add Method

Name Parameters Description
Add(CellRange, CellRange, String) sourceRange, location, name Creates a pivot table with a custom name based on data in the specified cell range and returns the newly created PivotTable object.
Add(CellRange, CellRange) sourceRange, location Creates a pivot table with the default name based on data in the specified cell range and returns the newly created PivotTable object.
Add(PivotCache, CellRange, String) cache, location, name Creates a new pivot table with a custom name using the specified data cache and returns the newly created PivotTable object.
Add(PivotCache, CellRange) cache, location Creates a new pivot table with the default name using the specified data cache and returns the newly created PivotTable object.