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