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