Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Source Data
I have been given an Excel file that is loaded with pivot tables and I can't
determine the source... well, I did find out that the data is coming from an Access database but I need to know where the database resides. Is there some way to find this out. Thanks very much! Jani |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Source Data
Hi Jani
Right click on the PT and select WizardBackshows source of data. If you needed to manipulate the source of the external data, then Ron Coderre has written a very nice utility program to achieve this which can be found at Debra Dalgleish's site http://www.contextures.com/xlPivotPlay01.html -- Regards Roger Govier "Jani" wrote in message ... I have been given an Excel file that is loaded with pivot tables and I can't determine the source... well, I did find out that the data is coming from an Access database but I need to know where the database resides. Is there some way to find this out. Thanks very much! Jani |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Source Data
Thanks so much for the quick reply and it is exactly what I needed!
"Roger Govier" wrote: Hi Jani Right click on the PT and select WizardBackshows source of data. If you needed to manipulate the source of the external data, then Ron Coderre has written a very nice utility program to achieve this which can be found at Debra Dalgleish's site http://www.contextures.com/xlPivotPlay01.html -- Regards Roger Govier "Jani" wrote in message ... I have been given an Excel file that is loaded with pivot tables and I can't determine the source... well, I did find out that the data is coming from an Access database but I need to know where the database resides. Is there some way to find this out. Thanks very much! Jani |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Source | Excel Discussion (Misc queries) | |||
Pivot table data source | Excel Discussion (Misc queries) | |||
Pivot Table data source | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Pivot Table Source Data | New Users to Excel |