Error Message when connecting pivot table to Access DB query

C

Chuck W

Hi,
I am getting an error message when attempting to connect a pivot table in
Excel 2007 to an Access 2003 query. I have set up several pivot tables in my
excel file that connect to this access database (and other databases as well)
and refresh properly. However, I can no longer set up any more pivot tables
to any access db. The error I get is "Test Connect Fialed because of an
error in initializing provider. Unspecified error". Nobody is in these
access databases and I can open up a blank excel file and successfully set up
pivot tables to these databases. Is anyone familiar with this error?

Thanks,
 

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 report invalid 0
Doughnut Chart linked with the slicer in the pivot table 0
Active Content in this file is blocked issue 1
Excel 2013 Pivot Data Range formula reference problem 0
Table Security in Access 2013 1
Excel 2010 Slicer Connection / Pivot Table Problem 3
Solved Disk Full error message when exporting PDF 0

Top