Create pivot table in excel 2007 from query in access 2007

Posted on 2012-09-06
Last Modified: 2012-09-06
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
Question by:Barbara69
    LVL 24

    Accepted 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.

    Author Comment

    I've done that. How do I refresh the pivot table from time to time when the query data changes?

    Author Comment

    I figured it out. All I have to do is go to the options tab and click refresh.

    Author Closing Comment

    I'm giving a B, because I had already performed the suggested solution before I came back to this site.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now