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 :-)
------------------------------­------------------------------­----------------
 
Back
Top