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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic PivotTable Data Source 1
Group Dates from SQL Query 1
Criteria for external data in a pivottable 1
Pivottable refresh in shared workbook 2
Linking PivotTable Fields - Excel 2007 1
Change the location of external data feeding a pivottable 4
Pivot Table Change Macro 1
PivotTables - Group Dates, excluding dates 2

Back
Top