Workbook using a new feature in Excel for Windows Data Model not opening in Excel for Mac.

I have updated my mac book air to the latest version( macOS High Sierra version 10.13.4)

I have also updated my 2016 excel from my office 365 subscription. 

The file opens normally but the slicers do no connect with the data from pivot tables as it was intended to do. When I try linking the data on the Data tab, New Database query, I get this message: 

 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.

The file works fully on my coworkers pc's Windows, Any ideas on what I have to do to open all functionality of this file on my mac?

I google OBDC drivers install, but most are paid downloads.

 

Question Info


Last updated August 11, 2018 Views 214 Applies to:

Previous replies from a different Microsoft forum:

The workbook you have is using a new feature in Excel for Windows called the Data Model. Until very recently you would have been given an alert that there is content in your workbook that is not supported in Excel for Mac. Please note the first data connection is to the Data Model. You are the first to report that you can actually get to the Data Model in any fashion in Excel for Mac, which to me is quite exciting because it means support for the Data Model is pretty far along in Excel for Mac. This is a great discovery!

Microsoft has said they are working on implementing the data model in Excel for Mac. Now I'm keen to try some things out myself to see what happens.

I urge you to join the Insider Fast program so you can have the in-house development build of Excel for Mac and get the very latest builds. I am sure Microsoft would like your feedback on how their work on the Data Model is working for you. You'll get the new feature months before everyone else does.

Once you get the Insider Fast build, try opening the workbook and see what happens. Then open a new question in the special Insider forum and share your experience.

What is Office Insider? - Office Support

I'm revising my answer after opening a workbook that has a data model in it. The data model was imported from a an Excel workbook named Emissions.xlsx. The workbook's Workbook Connections dialog shows the Excel Emissions as a data source, so there's a connection to that file.

In the screenshot you took, it would seem that there is a connection to a worksheet as the data source for the Data Model in the workbook you have.

I don't see any way to get at the Data Model from the Mac interface. Let me see what happens in Windows.

In Windows I made a PivotTable from a Data Model and then made a slicer using the PivotTable. Then I saved the file and opened it on my mac in version 16.14 Insider Fast.

The PivotTable displays, but Excel for Mac does not recognize it as a PivotTable. When I select a cell in the PivotTable, the PivotTable Ribbon tabs do not display. The slicer displays, but nothing happens when I click the buttons. When I try to use the Filter button on the PivotTable I get this alert:

When I right-click in the PivotTable most options are turned off

All of this suggests that full support is on the way! This is very encouraging.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Screen shots from my issue opening the full functionality of the file.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

That is also what I see.

Please install the Insider Fast build and comment about it in the Excel Insider forum. Obviously everything is not hooked-up yet, but they are working on it.

A quick look in the Object Model in the VB Editor shows that Data Model support is also being built for VBA.

I am an unpaid volunteer and do not work for Microsoft. "Independent Advisors" work for contractors hired by Microsoft. "Microsoft Agents" work for Microsoft Support.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.