| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Find outside source
How can I find the outside source for the a pivot table? The table is based
off an access DB. I know how to get to the point that I can see all the tables in the access file, but there are many diffrent tables. I need to know how to find out what table in the DB is driving the data in my pivot table. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Find outside source
I figured this out. By canceling out of the "Get Data" portion of the pivot
table wizard it asks if you want to continue editing. If you select yes it brings up the querie that excel uses and the name of the table is in the listbox at the top. "Robert_DubYa" wrote: How can I find the outside source for the a pivot table? The table is based off an access DB. I know how to get to the point that I can see all the tables in the access file, but there are many diffrent tables. I need to know how to find out what table in the DB is driving the data in my pivot table. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| OLAP Pivot Table - HT Find source data | Excel Discussion (Misc queries) | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| Transforming pivot table back to the source table | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Hybrid Mode
