| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Source | Excel Discussion (Misc queries) | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| Transforming pivot table back to the source table | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Hybrid Mode
