| Home |
| Search |
| Today's Posts |
|
#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? |
| 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
