Office
Sign in
Fixes or workarounds for recent issues in Excel for Mac

Fixes or workarounds for recent issues in Excel for Mac

Last updated: June, 2018

Excel for Mac crashes and slow performance

Issues affecting Excel for Mac features and add-ins

Last updated: March 6, 2018

ISSUE

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.

STATUS: FIXED

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

ISSUE

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".

STATUS: WORKAROUND

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

ISSUE

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.

STATUS: WORKAROUND

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 4, 2017

ISSUE

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.

STATUS: WORKAROUND

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

Chat

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.

×