Fixes or workarounds for recent issues in Excel for Mac

Last updated: January 2017

Excel for Mac crashes and slow performance

Last updated: January 2017

ISSUE

Apple released macOS 10.12 Sierra on 9/20/2016. Some customers are reporting Office 2016 for Mac applications are closing unexpectedly, or crashing when an Office application is launched, or when the computer is moved between Wi-Fi networks (e.g. moving a laptop from home to work).

Customers in a workplace or school network configuration who wish to upgrade to macOS Sierra should update to macOS Sierra 10.12.2 or later, for improved stability specific to proxy networks.

WORKAROUND

Turning off “Auto Proxy Discovery” or “Automatic Proxy Configuration” is a possible workaround, if allowed by your organization’s network configuration.

  1. Go to System Preferences and open Network.

  2. Click on Advanced and go to Proxies.

  3. Check if "Auto Proxy Discovery" or "Automatic Proxy Configuration" is turned on.

Contact your local network administrator for more information on your network settings.

We will update this content when more information is known, including a fix or additional workaround.

Issues affecting Excel for Mac features and add-ins

When copy/pasting a formula on the iPad, Excel pastes just the values. The Excel Team released a fix on November 14th in build 1.27.16111300.

Prior to the fix being available, we provided a workaround related to the iPad's "Speak Selection" setting; if you used that workaround, you may want to reverse it. Now that we released a fix, it no longer matters whether Speak Selection is off or on.

To turn this setting off, go to System Settings > General > Accessibility > Speech > Speak Selection > (On).

When using JustSystems ATOK add-in in Office 2016 for Mac 64-bit (version 15.25 or later), you may experience one of the following:

  • Word or Excel error message: "Compile error in hidden module: 'Module1'. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application."

  • Excel error message:
    "Compile error in hidden module: 'ThisWorkbook'. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application."

This is a known compatibility issue. For more information on this error, go to https://support.justsystems.com/faq/1032/app/servlet/qadoc?QID=056175 (Note: Link goes to JustSystems Japanese language website).

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 Us button at the bottom of this page.
If you are an admin for Office 365 for business subscription, contact Office 365 for business support.

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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×