finding pivot table base data

  • Thread starter Thread starter dindigul
  • Start date Start date
D

dindigul

I have been forwarded an excel sheet which contains many tables. However,
the tables have similar headings. It also has a couple of pivot tables. My
problem is that I want to know on which particular sheet of data a
particular pivot table is based on. Is there a way to find out? Thanks
 
Right click on the Pivot table and choose "Pivot table Wizard" and then hit
"Back". This will take you to the sheet where the data is pulling from.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
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

Export Pivot table 1
How to base a pivot table on another pivot table? 3
Pivot Table Help! 1
Pivot Table Source file 2
Consolidate Pivot Tables/Cache using Excel 2003 1
making an excel table visible for external data on pivot table 1
Adding Report Filters to Excel Pivot Tables via VB. 1
reference is not valid message for pivot tables based on Access query 4

Back
Top