| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
You can change the source programmatically. For example:
ActiveWorkbook.PivotCaches(1).CommandText _ = "SELECT *" & Chr(13) & "" & Chr(10) & _ "FROM `c:\Data\Test.mdb`.qryInvDate" zoeloe wrote: Hi all, i have an excel pivottable with a datasource pointing to an access database located on a share. Now i want to move the database to a different directory. How can i change the datasource location of the pivottable? thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
| How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
| Chart DataSource Change | Charts and Charting in Excel | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Hybrid Mode
