Page History

}
{description}

{excerpt}
Changes the data source of the {{PivotTable}} to a new {{[Area]}}.
{excerpt}

{signature:C#}
public void ChangeDataSource(Area newArea)

{signature}

{signature:vb.net

}
Public Sub ChangeDataSource(ByVal newArea As Area)

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

An exception of type ArgumentException will be thrown if:

{code}
{example}


{exceptions}

{exception: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)

{exception}