Change pivottable datasource

  • Thread starter Thread starter zoeloe
  • Start date Start date
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!
 
You can change the source programmatically. For example:

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