Advice needed: I have 2 MS Access dbs which are the data source for 2 Excel
workbooks. These workbooks contain about 30 pivot tables in each book. Each
pivot table is linked via MSQuery to an Access query. These pivot table links
are hard coded behind the scenes. How can I use VBA to re-link these PTs to
MS Query.

TIA
Johnb