finding pivot table base data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dindigul - 28 Oct 2007 21:28 GMT

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

Reply to this Message

Ken Wright - 28 Oct 2007 21:40 GMT

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.

Signature

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

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

>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

Reply to this Message

Rate this thread: