Changes the data source of the PivotTable to a new Area.

public void ChangeDataSource(Area newArea)


Public Sub ChangeDataSource(ByVal newArea As Area)

An Area object representing the new data source in the same workbook.

Area newArea = worksheet.CreateArea("A1:C7");
pivotTable.ChangeDataSource(newArea);

Dim newArea As Area = worksheet.CreateArea("A1:C7")
pivotTable.ChangeDataSource(newArea)

An exception of type ArgumentException will be thrown if:

  • A null reference is passed in as a parameter instead of a valid Area object
  • The new data source is not in the same workbook
  • Not every cell in the first row of the new area contains a value for the column name
  • The area for the new data source only has one row (PivotTables require at least two)