Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Current »

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