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.

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.