Introduced in build 8.4
Description
Changes the data source of the PivotTable
to a new Area
.
C#
vb.net
Parameters
newArea
AnArea
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 validArea
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)