Description
Changes the data source of the pivot table.
C#
vb.net
Parameters
newArea
An Area object representing the new data source in the same workbook.Examples
C#
vb.net
Exceptions
ArgumentException
If anull
reference is passed in as parameter instead of a valid Area object, if the new data source is not in the same workbook, orif not all the cells in the first row of the new area contain a value for the column name, then an exception of type
ArgumentException
will be thrown.