{introducedin: 8.4} {description} {excerpt} Changes the data source of the {{PivotTable}} to a new {{[Area]}}. {excerpt} {signature:C#} public void ChangeDataSource(Area newArea) {signature} {signature:vb.net} Public Sub ChangeDataSource(ByVal newArea As Area) {signature} {parameters} {param:newArea} An {{[Area]}} object representing the new data source in the same workbook. {param} {example} {code:csharp|title=C#} Area newArea = worksheet.CreateArea("A1:C7"); pivotTable.ChangeDataSource(newArea); {code} {code:vbnet|title=vb.net} Dim newArea As Area = worksheet.CreateArea("A1:C7") pivotTable.ChangeDataSource(newArea) {code} {example} {exceptions} {exception:ArgumentException} 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) {exception} |