Windows 7 64 Bit Excel query error

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I have an Excel 2007 pivot table with data that resides in Access 2007. In a
32 Bit environment the pivot table refreshes without error.

I installed Win 7 64 bit and office 2010 64 bit. I try to refresh data, but
get an error. "The query did not run, or the database table could not be
opened."
I uninstalled Office 2010 and installed 2007. However the problem persist.
I'm assuming it's an issue with 64 Bit of Windows 7. Thanks in advance for
your help.
 
Resolved with Excel 2007.

My ODBC connection was not working properly. Although i had created an ODBC
connection, when i tried to link another table through "SQL" in Access it
would work. I looked at my connections and noticed there wasn't one. So i
recreated it and everything works.
 
Back
Top