Pivot table data source

J

John Rozario

Hi!

I had some pivot tables in my computer. How can I find the
data source name or the database name where the data is
coming from? I went to the get data and view SQL but it
did not show me the database name and location. Any help
will be appreciated.

Thanks.
John
 
L

Laurence Lombard

I normally right click on the pivot table, select wizard and then the back
button until you get to the window with the source data range in it.
Laurence
 
Top