Excel Blog Filter by label Filter by label Announcements Blog Collaboration Conference Data Data Insights dynamic arrays Excel Excel 2016 Excel for good - supporting your child's learning at home Excel Online Filter Get & Transform Get & Transform Data Get Data Ignite import Insights Interoperability Mac microsoft Office 365 PivotChart. Microsoft Excel is one of the most versatile and useful programs in the Office suite. It doesn’t matter if you need Excel templates for budgeting the next fiscal year, tracking your business inventory, planning out meals, or creating a fantasy football draft sheet, there are plenty of Microsoft Excel templates for you.
- Microsoft Excel 2016 For Mac Review 2015
- With Editor For Review
- Microsoft Excel 2016 For Mac
- Highlights For Review
Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
Excel 2016 for Mac crashes when you click Data > New Database Query > From Database.
Cause
This issue occurs if you 're running Excel 2016 for Mac version 15.25 or later, and you have an older 32-bit ODBC driver installed on your Mac.
Microsoft Excel 2016 For Mac Review 2015
Resolution
To resolve this issue, remove the 32-bit driver, and then install a new 64-bit driver. For information about how to remove and install the drivers, contact the driver manufacturer or supplier.
More Information
In September 2015, Excel 2016 for Mac was originally released as 32-bit software. However, in August 2016, the software was updated to 64-bit. To check whether you have this update, click About Excel on the Excel menu. If you have version 15.25 or later, you have the 64-bit version.
If you have the 64-bit version and an older 32-bit ODBC driver, this may cause Excel to crash. To prevent this issue, install a 64-bit driver from the provider or from the company's website. Some of the most common drivers are provided by Openlink Software and Actual Technologies.
To determine whether your driver is 32-bit or 64-bit, follow these steps:
With Editor For Review
- Go to the Finder.
- Click Go > Utilities, and then double-click System Information.
- On the left side, scroll down, and then click Applications.
- Scroll through the list of applications to find the name of your driver.
- Click the driver, and then look in the 64-bit column.
Microsoft Excel 2016 For Mac
For more information about compatible ODBC drivers, see ODBC drivers that are compatible with Excel for Mac.
Third-party information disclaimer
Highlights For Review
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.