The free Pivot Play add-in, located at Debra Dalgleish's website, may help:
http://www.contextures.com/xlPivotPlay01.html

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"ryguy7272" wrote in message
...
Without right-clicking on a Pivot Table, then clicking Pivot Table Wizard

Back, and seeing the reference to the data in the Pivot Table, is there
another way to view the source data? A friend told me that he gets files
with Pivot Tables, but he can't find the source data. Obviously it could
come from an external database. I suspect it would be impossible to see
the
reference to that DB. Is this correct?

Regards,
Ryan---



--
RyGuy