Page History

Introducedin

	8.4
	8.4

Description

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

Signature

	C#
	C#

public void ChangeDataSource(Area newArea)

Signature

	vb.net
	vb.net

Public Sub ChangeDataSource(ByVal newArea As Area)

Parameters

Param

	newArea
	newArea

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

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