Change pivottable datasource

Z

zoeloe

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!
 
D

Debra Dalgleish

You can change the source programmatically. For example:

ActiveWorkbook.PivotCaches(1).CommandText _
= "SELECT *" & Chr(13) & "" & Chr(10) & _
"FROM `c:\Data\Test.mdb`.qryInvDate"
 
Top