Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change pivottable datasource
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! -- zoeloe ------------------------------------------------------------------------ zoeloe's Profile: http://www.excelforum.com/member.php...o&userid=24479 View this thread: http://www.excelforum.com/showthread...hreadid=380795 |
#2
|
|||
|
|||
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) |