Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{introducedin: 8.4}

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)