Windows 7 64 Bit Excel query error

[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.

 

[Al]

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.