How to change Pivot Table external data source (MS Access Database)by VBA

J

John Chi

Dear all,

I have several pivot tables linked to a MS Access Database. And currently the MS Access Database has moved location, How can I update the link to MS Access Database by VBA?

Thanks very much!
 

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

Adding data to MS Access from csv file 0
Dynamic Naming of Form Button 3
Word VBA - Automatic change content of a cell in table using dropdown list 5
Linking data in MS Word into Excel 5
How do I clear a form? 0
Pivot table report invalid 0
Slicers and Calculated Items in Pivot Table 2
Excel 2013 Pivot Data Range formula reference problem 0

Top