Pivot table data source

  • Thread starter Thread starter John Rozario
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move and Copy Pivot Table and Source Data 4
Easy way to change Pivot table source files? 5
pivot table data 2
Pivot Table Data Source 1
View Pivot Table Source data as a Data Table 6
View pivot table external data source in Excel 2007 4
Pivot table change data source 1
Column limit for Pivot Table data source 1

Back
Top