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

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

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