Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

153 views
Skip to first unread message

John Chi

unread,
Jun 10, 2012, 11:12:51 AM6/10/12
to
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!
0 new messages