Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

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

C#
vb.net

Parameters

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

Examples

C#
vb.net

Exceptions

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)
  • No labels