Excel Pivot Table cannot see Access Table

N

nthdegree

I'm having an issue with an Excel Pivot table not seeing any table in a
particular Access DB. I am able to pivot off of tables in other databases
without issue. Anytime I attempt to pivot off this database though I get the
following error message: "This data source contains no visible tables". But
it does.
What's weird, is that I can take a second database, link in the tables from
the original DB in question and then pivot off of them without issues.
 

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

Dealing with a Pivot Table (when I don't want to) 0
pivot table missing rows? 0
Formula to Look up values from a pivot table 1
Connection files and pivot tables 0
making an excel table visible for external data on pivot table 1
Table Security in Access 2013 1
Slicers and Calculated Items in Pivot Table 2
Excel 2007 pivot table using analysis services cube as data source 0

Top