PivotTable.ChangeConnection Method
Changes the connection of the specified PivotTable.
Version Information
Version Added: Excel
Syntax
expression.ChangeConnection(conn)
expression A variable that represents a PivotTable object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| conn | Required | WorkbookConnection | A WorkbookConnection object that repesents the new conneciton for the PivotTable. |
Remarks
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.