| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Connection
I am trying to change the data source of my pivot table.
The code that I normally use is: ActiveCell.PivotTable.PivotCache.Connection = "ODBC;DSN=GENERAL LEDGER;" However I keep getting the follwoing message: Run-time error '1004': Application-defined or object-defined error Does anybody have any suggestions as to my this might be happening? TIA. Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Affect a new connection to a pivot table | Excel Discussion (Misc queries) | |||
| Connection of Excel 07 pivot table to Access Query makes DB read o | Excel Discussion (Misc queries) | |||
| Pivot Table loses Data Connection | Excel Discussion (Misc queries) | |||
| Pivot Table Connection String - How to hide it? | Excel Discussion (Misc queries) | |||
| Copy pivot table and get rid of connection | Excel Discussion (Misc queries) | |||
![Steven Taylor[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
