PivotTable.ChangeConnection (Excel)

Changes the connection of the specified PivotTable object.

The ChangeConnection method can only be used with a PivotTable that is connected to an external data source. A run-time error occurs if the ChangeConnection method is used with a PivotTable that uses data stored on a worksheet as its data source.

ChangeConnection (conn)

conn: A WorkbookConnection object that represents the new connection for the PivotTable.

ActiveCell.PivotTable.ChangeConnection conn:=