| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing source of a pivot table
Thanks to both of you. That solves it.
"Debra Dalgleish" wrote: Ron Coderre has a pivot table add-in that lets you view and edit the connection string: http://www.contextures.com/xlPivotPlay01.html hbear wrote: I'm setting up a workbook with approximately six pivot tables per page. Each pivot table is attached to a separate query in an external database. I've just noticed, however, that all pivot tables on a page are pulling the same data. What might be causing this? And how can I view the source of each pivot table (the actual address of the queries, not the data produced by drilling down) so I can verify that they're all attached correctly? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Data Source for Pivot Table | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Determine the location of an external source of pivot table? | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
Threaded Mode
