Pivot Table Source Data

J

Jani

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
 
R

Roger Govier

Hi Jani

Right click on the PT and select Wizard>Back>shows 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table using analysis services cube as data source 0
Slicers and Calculated Items in Pivot Table 2
Pivot Table Counting Text Data 0
Sharing Excel 365 Mac<->PC 0
Column limit for Pivot Table data source 1
Excel 2007 vlookup with Pivot table 0
View Pivot Table Source data as a Data Table 6
Pivot table change data source 2

Top