|Excel Developer Reference|
Version Added: Excel 2007
expression A variable that represents a PivotTable object.
|conn||Required||WorkbookConnection||A WorkbookConnection object that repesents the new conneciton for the PivotTable.|
The ChangeConnection method can only be used with a PivotTable that is connected to an external data source. A run-time error will occur if the ChangeConnection method is used with a PivotTable that uses data stored on a worksheet as its data source.