Finding the Access query a pivot table is based on

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChuckW - 21 Mar 2008 16:50 GMT

Hi,

I took over some reporting from someone else who created pivot tables based
on some access queries. All I need to do is to refresh the pivot table to
get updated data. I want to find out which query in my access database the
pivot table is using but cannot seem to locate this. Is there a way in excel
to identify this?

Thanks,

Signature

Chuck W

Reply to this Message

Ron Coderre - 21 Mar 2008 17:13 GMT

Perhaps one of these approaches:

Method_1:
Right-Click on the pivot table
Select: Pivot Table Wizard
...Click the [Back] button
...Click the [Get Data] button

That should open MS Query
...where you'll be able to see and edit the
details by clicking the [SQL] button

Method_2:
Use the Pivot Play PLUS add-in at
Debra Dalgleish's website (don't worry,it's free):
http://www.contextures.com/xlPivotPlayPLUS01.html

Then you can easily view and edit the data source and the SQL.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

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

> Hi,
>
[quoted text clipped - 8 lines]
>
> Thanks,

Reply to this Message