Excel 2016 for Mac crashes when you click the From Database option
Excel 2016 for Mac crashes when you click Data > New Database Query > From Database.
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:
- 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.
For more information about compatible ODBC drivers, see ODBC drivers ODBC drivers that are compatible with Excel for Mac.
Third-party information disclaimer
Article ID: 3185692 - Last Review: 08/22/2016 02:17:00 - Revision: 4.0