Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-Linking Pivot tables to MS Query
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-Linking Pivot tables to MS Query
Look at the connection property of the the PivotCache Object. Look at what
the current value is then make the changes to that string and reassign it. There is also a hidden SQL property that you might want to look at. -- Regards, Tom Ogilvy "johnb" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-Linking Pivot tables to MS Query
Hi Tom,
Thank you for the comment. The hidden SQL property, is it found under ..CommandType = xlCmdSql ?? johnb "Tom Ogilvy" wrote: Look at the connection property of the the PivotCache Object. Look at what the current value is then make the changes to that string and reassign it. There is also a hidden SQL property that you might want to look at. -- Regards, Tom Ogilvy "johnb" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking Pivot tables | Excel Discussion (Misc queries) | |||
Linking Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables / Linking Worksheets | Excel Programming | |||
linking pivot tables by page fields | Excel Programming | |||
Linking excel pivot tables | Excel Discussion (Misc queries) |