Posted to microsoft.public.excel.programming

external usenet poster

Posts: 53

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
linking Pivot tables	amydawn10	Excel Discussion (Misc queries)	0	January 4th 08 09:56 AM
Linking Pivot Tables	Pete	Excel Discussion (Misc queries)	0	July 5th 06 04:40 PM
Pivot Tables / Linking Worksheets	p@ty	Excel Programming	1	May 26th 06 04:17 PM
linking pivot tables by page fields	Nelson[_9_]	Excel Programming	1	March 30th 06 02:16 PM
Linking excel pivot tables	[email protected]	Excel Discussion (Misc queries)	1	February 24th 06 12:28 AM

All times are GMT +1. The time now is 06:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us