| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing source of a pivot table
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Viewing source of a pivot table
Click onto the Pivot Table you want to see the Data Source. Right click onto
PivotTable Wizard. Click on the "Back" button and it will show the Data Source and Range. "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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Viewing source of a pivot table
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 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
