Trouble using Access as source for Pivot Table

J

jondmontgomery

Joined
Mar 12, 2009
Messages
1
Reaction score
0
I am trying to use an 2003 Access database as a source for a pivot table in 2003 Excel. When I get to the part to select the columns/tables from the database, I do not get the drill-down options. The wizard will show me the tables/queries in the database, but will not let me expand to show the fields.

I have tried this with similar databases without encountering any issues. Has anyone run across this before?
 
Last edited:

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

Access query not showing as sources for pivot table 2
pivot table data 2
Checking/amending the external source link to an Access table 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
pivot table source data expand to new entries when refresh? 4
How can I change the source data reference to another pivot table? 2
Pivot table wizards 2
Move and Copy Pivot Table and Source Data 4

Top