Good morning All,
I am trying to open a spreadsheet which is on a shared driver (workbook was setup using a windows machine). The workbook has a macro to refresh itself every time on opening. However when I try opening the workbook using a Mac (my boss's machine), it comes up with the following errors:
"Microsfoft Excel cannot complete this operation
because the ODBC Manager Driver is not installed. To
installe the ODBC Driver Manager, run setup and instal
the database driver for the type of database(s) you want
to access"
I haven't used Macs much, so thought I would get some guidance before I start clicking away?
The machine has Excel 2016 for Mac installed, and the MSQuery imbedded in the workbook is trying to look up information from another excel workbook
Any help much appreciated.
Regards
Herbert
I am trying to open a spreadsheet which is on a shared driver (workbook was setup using a windows machine). The workbook has a macro to refresh itself every time on opening. However when I try opening the workbook using a Mac (my boss's machine), it comes up with the following errors:
"Microsfoft Excel cannot complete this operation
because the ODBC Manager Driver is not installed. To
installe the ODBC Driver Manager, run setup and instal
the database driver for the type of database(s) you want
to access"
I haven't used Macs much, so thought I would get some guidance before I start clicking away?
The machine has Excel 2016 for Mac installed, and the MSQuery imbedded in the workbook is trying to look up information from another excel workbook
Any help much appreciated.
Regards
Herbert