Hi everyone,

I really need some help with this problem. I have built an Excel that uses timesheet data from a MySQL database. It drives a lot of functionality in our business, for example how many hours to invoice our customers, invoice amounts, etc. I have sent a new version of the pack to one of our managers who runs Excel on his MAC. He has an ODBC driver for MySQL and a connection is set up to connect to the database. He was able to refresh the data on an older version of the spreadsheet, but with the new version he gets an error [Expression.Error] The import Odbc.DataSource matches no exports, did you miss a module reference?

The older version of the spreadsheet returned the table data from the database in a "blue" table in excel and the new version returns it in a "green" table. I suspect the new spreadsheet is using Power Query whilst the older spreadsheet used MS Query. I upgraded to Excel 2019 on my Windows laptop before building the new version of the spreadsheet.

Is there a way to refresh data from Power Queries on Excel MAC? Alternatively, is there a way that I can change the queries on my master spreadsheet back to simple data queries, instead of Power Queries?

Many thanks,
Johann