We have an Access database that uses sharepoint tables. We have linked an Excel spreadsheet to the Access query. The Excel sheet refreshes ok on a Window XP, 32 bit, Office 2010 computer. The file does not refresh on a Windows 7, 64 bit, Office 2010 computer. The user receives the following error message.

Cannot reference a table with a multi valued field using a From clause that refers to another database.

The fact that one machine works and another one doesn't make me wonder if there is setting that needs to be changed on the Windows 7, 64 bit machine. Any help is greatly appreciated.

Thanks,
Jeff