Share via

Excel ODBC Driver Manager Not Installed

Anonymous
2023-11-06T01:51:29+00:00

Hello,

I am trying to refresh all my data in my Excel file in my Macbook but I am getting an error that "Microsoft Excel cannot complete this operation because the ODBC Driver Manager is not installed. To install the ODBC Driver Manager, run Setup and install the database driver for the type of database(s) you want to access."

I have Macbook Sonoma and my Excel version is Microsoft Excel for Mac version 16.78. I installed iODBC Stable Version 3.52.16 but still getting the same message above. The Excel file was working from my Windows computer.

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2023-11-07T01:57:54+00:00

    Hi

    Mac OS used to come with ODBC drivers, but Apple decided to cut costs and stopped supplying ODBC drivers more than a decade ago.

    Microsoft Excel for Mac comes with one ODBC driver built-in, and that is for Microsoft SQL Server.

    If you want to make ODBC connections, you need to install a driver that works with the kind of data source you want to connect to. For network connection based data sources I prefer the drivers from OpenLink Software. For file-based data sources my preference is Actual Technologies. I have used drivers and support from both companies and I highly recommend both of them.

    As you add data sources, the chooser dialog will populate. Here's mine at the moment:

    I'm not sure what steps you followed to get to the point you got stuck. You have to add a data source connection to the data source before you can use the data.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-11-07T21:49:16+00:00

    I used Actual SQL server. The test connection was successful but when refreshing my data on my excel, I get "[iODBC][Driver Manager] specified driver cloud not be loaded.

    When I click Get Data > From Database > From SQL Server Database and enter information in there, I was able to run and get SQL statement. I need the "Refresh All" to be working on my Mac. I don't have any issues from my windows.

    0 comments
  3. Anonymous
    2023-11-06T18:53:16+00:00

    After installing the ODBC Manager, I got "iODBC Driver Manager specified driver could not be loaded. I won't be able to run it now because I'm not in my company's network. I just need to get rid of the ODBC manager or driver not found error message. When opening the ODBC Manager, everything is empty just like in Windows, we have default drivers on it. Should I add and do the same connection as what I have in my windows?

    0 comments
  4. Anonymous
    2023-11-06T08:57:19+00:00

    Dear 9324Mi2512,

    Good day! Thank you for posting your query in our community.

    Based on your description, you received an error when you refresh data in Excel file on Macbook. About the error message, it is possible that the iODBC you installed is not compatible with Excel for Mac.

    We suggest you can try to download ODBC from best official link to see the result: ODBC drivers that are compatible with Excel for Mac - Microsoft Support.

    .

    Sincerely,

    Jazlyn | Microsoft Community Moderator

    0 comments
  5. Anonymous
    2023-11-06T05:31:06+00:00

    Dear 9324Mi2512,

    Good da y!

    Thank you for posting to Microsoft Community. We are glad to assist. We are looking into your situation and we will update the thread shortly.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely.

    Microsoft Community Moderator

    0 comments