Description
Changes the data source of the pivot table.
C#
vb.net
Parameters
newArea
AnArea
object representing the new data source in the same workbook.
Remarks
$bodyExceptions
ArgumentException
If a null reference is passed in as parameter instead of a valid Area object, or 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.