Message-ID: <1650797354.10355.1711722457532.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10354_185752635.1711722457532" ------=_Part_10354_185752635.1711722457532 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html PivotTable.ChangeDataSource(Area)

PivotTable.ChangeDataSource(Area)

Introduced in build 8.4

=20

Description

= =20

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

=20
C#
=20
public void ChangeDataSource(Area newArea)

=20
=20
vb.net
=20
Public Sub ChangeDataSource(ByVal newArea As Area)

=20
=20

Parameters

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

Examples

=20
C#
=20
Area newArea =3D worksheet.CreateArea("A1:C7");
pivotTable.ChangeDataSource(newArea);
=20
=20
vb.net
=20
Dim newArea As Area =3D worksheet.CreateArea("A1:C7")
pivotTable.ChangeDataSource(newArea)
=20
=20

Exceptions

=20
ArgumentExce= ption
=20

An exception of type ArgumentException will be thrown if:=20

------=_Part_10354_185752635.1711722457532--