Fixes or workarounds for recent issues in Excel for Mac

Last updated: March, 2018

Excel for Mac crashes and slow performance

Last updated: February 8, 2018


You may experience lag moving between cells using your cursor keys. This occurs in Build 16.9 (18011602).


We are aware of this issue and working on a fix. In the meantime, try unchecking the Automatically fill formulas box in Excel Preferences as a workaround. Information for this issue is also provided in Scrolling between cells in Excel 2016 for Mac is slow.

Issues affecting Excel for Mac features and add-ins

Last updated: March 6, 2018


When you click a hyperlink to open a file or folder, it may not open a Finder window to show the folder or it may not open the linked file.


This issue has been fixed in version 16.11.0 or higher. To get the latest update, open Excel for Mac, go to the Help > Check for Updates menu, and follow the instructions in the AutoUpdate app. For the most recent information on this issue, go to Problem opening files or folders via hyperlinks in Excel 2016 for Mac.

Last updated: November 10, 2017


In Excel for Mac, a new Visual Basic editor was introduced in October 2017. With this new VB editor, there's an issue with creating object declarations by choosing from the drop-down menu at the top of the code window resulting in an error: "Variable uses an Automation type not supported in Visual Basic".


For the most recent information on this issue, go to "Variable uses an Automation type not supported" error in Visual Basic editor in Excel for Mac.

Last updated: October 19, 2017


When you click "Export to Excel" to export a SharePoint list on a Mac, it doesn't open the file in Excel for Mac and instead downloads the query.iqy file. This is working as expected as the internet query connection is not supported by Excel for Mac.


If you have Excel for Windows, you can save the file as XLSX and then open it in Excel for Mac. You'll be able to see the data but you won't be able to refresh the data connection.

Last updated: October 13, 2017


When trying to filter a column that contains only date values, the filter list is empty, so you are not able to set the filter. This issue affects Excel 2016 for Mac version 15.38 and 15.39.


We are actively working on a fix for this issue. As a workaround, you may be able to filter your data as needed using the filter options above the filter values list.

Excel for Mac filter date values

Last updated: October 4, 2017


We are aware of an issue affecting Excel 2016 for Mac users. Problems are reported rendering Excel worksheets, causing text to display as backwards or upside-down.


This occurs on a Mac with macOS High Sierra beta and Excel 2016 for Mac Insider's Fast update. This should be resolved when the next Insider's Fast update is released.

As a workaround, you can uninstall the Excel 2016 for Mac Insider Fast version and install the production version of Excel on your Mac.

Need more help?

Call support

Talk to support.
If you have an Office 365 for home subscription, or you purchased a one-time download of Office 2016, click the Contact Uslink at the bottom of this page.

Office 365 community forums

Ask the community
Get help from experts in our forums:
Office for Mac community for Mac users


Provide feedback in Office app
You can send feedback directly to our Office teams:.

For Mac users, in Office 2016 for Mac, click the smiley icon in the upper-right corner.

Click an option to give feedback.

Have a feature request?

Lightbulb - Idea

We love reading your suggestions on new features and feedback about how you use our products! Share your thoughts on the Excel UserVoice site. We’re listening.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.