PivotTable.ChangeConnection Method (Excel)
Changes the connection of the specified PivotTable.
Version Information
Version Added: Excel 2007
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.