Excel-Access

I installed an Excel spreadsheet on a user’s desktop, which contains a Macro.
When selected, the Macro is suppose to retrieve data from Access using Microsoft queries. Instead, it appears it is looking for the ODBC driver. When I tried to refresh the data without using the macro I received an ODBC error.