Changes the data source of the pivot table.

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