finding pivot table base data

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
 
K

Ken Wright

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