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

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