PivotTable.ChangeConnection Method (Excel)
Changes the connection of the specified PivotTable.
Version Information
추가된 버전: Excel 2007
Syntax
식 .ChangeConnection(conn)
식 A variable that represents a PivotTable object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
conn |
필수 |
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.