Thats why youll notice an interface thats consistent with what youd expect when using Office 2016 for Windows, and why we added support for virtually all of the Windows Excel Ctrl keyboard shortcuts.

So when it came to working with external data, we applied that same logic: how can we make the experience great and working cross platform easier than ever.

This means several great things for anyone who works with external data.

Have a workbook with ODBC data connections youve been using on Windows and never been able to use on your Mac Well, now you can with cross-platform compatibility.

It provides a central place to see all of the data connections in a workbook, see where they are used, and modify, remove or refresh each one individually.

All of your connections are displayed, and you can click any of them to see where they are used in your workbook and to perform any action.

On the Data tab, simply select New Database Query SQL Server ODBC, and you are presented with a simple connection dialog.

Simply enter a SQL statement, click Run Query to make sure it works.

Once it does, click Return Data to drop your data right back into your worksheet.

And thats it; your data is now in your Excel workbook, live and ready to use in Excel 2016 for Mac or Excel for Windows.

The only difference is that after installing the data provider, you select New Database Query From Database and then select your data provider from the Apple iODBC manager.

Give it a try and let us know of any questions or feedback you have in the comments.

Install Simba Driver In Excel For Mac