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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to change Pivot Table external data source (MS Access Database)by VBA (https://www.excelbanter.com/excel-programming/446289-how-change-pivot-table-external-data-source-ms-access-database-vba.html)

John Chi

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

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!

All times are GMT +1. The time now is 01:24 PM.