• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Create pivot table in excel 2007 from query in access 2007

I want to create a pivot table in excel 2007 from a query that uses other queries and tables to run in access 2007 as well as have the ability to update the pivot table if the query data has changed without recreating the pivot table each time the query data changes. I tried the following, but my query isn't listed.

In Excel, on the Data tab, click From Access
Select your database, click Open
Select the query, click OK
Select PivotTable report, click OK
  • 3
1 Solution
In Excel
data tab > 
from other sources > 
MS Query > 
Access Database (take the time to turn off the use wizzard tick box)
Select database
In builder turn off auto caculate
Select the query you want
File > Return data to excel
As pivot table.
Barbara69Author Commented:
I've done that. How do I refresh the pivot table from time to time when the query data changes?
Barbara69Author Commented:
I figured it out. All I have to do is go to the options tab and click refresh.
Barbara69Author Commented:
I'm giving a B, because I had already performed the suggested solution before I came back to this site.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now