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");
Dim newArea As Area = worksheet.CreateArea("A1:C7")

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)