Skip to main content
A newer version of this page is available. .
.NET Framework 4.5.2+
Row

PivotTableCollection.Add Method

Name Parameters Description
Add(PivotCache, Range, 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, Range) cache, location Creates a new pivot table with the default name using the specified data cache and returns the newly created PivotTable object.
Add(Range, Range, 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(Range, Range) 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.