Pivot Table Source
 

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 cant 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

Pivot Table Source
 

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

Pivot Table Source
 

Oh my! I have seen this before!! There is just too much to remember with
Excel!! Thanks for pointing me in this direction. I am grateful for these
discussion groups.

Thanks a bunch Ron!!


Regards,
Ryan--

--
RyGuy


"Ron Coderre" wrote:

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

Pivot Table Source
 

I'm so glad Pivot Play was helpful, Ryan.....Thanks for letting me know.

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

Regards,

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


"ryguy7272" wrote in message
...
Oh my! I have seen this before!! There is just too much to remember with
Excel!! Thanks for pointing me in this direction. I am grateful for
these
discussion groups.

Thanks a bunch Ron!!


Regards,
Ryan--

--
RyGuy


"Ron Coderre" wrote:

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