Thread: How to change Pivot Table external data source (MS Access Database)by VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Chi John Chi is offline
external usenet poster
  
Posts: 1
Default 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!
Reply With QuoteReply With Quote