Page History

Introducedin

	8.4
	8.4

Description

Excerpt
Changes the data source of the pivot table `PivotTable` to a new `Area`.

Signature

	C#
	C#


&nbsp;public void ChangeDataSource(Area newArea)

Signature

	vb.net
	vb.net


&nbsp;Public Sub ChangeDataSource(ByVal newArea As Area)

Parameters

Param

	newArea
	newArea

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

Remarks

Example

Code Block


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

Code Block


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

Exceptions

Exception

	ArgumentException
	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)

Versions Compared