Fixes or workarounds for recent issues in Excel for Windows

Fixes or workarounds for recent issues in Excel for Windows

Last updated: November, 2017

Excel crashes and slow performance

Last Updated: November 20, 2017

ISSUE

You may experience problems loading the Excel Solver add-in if you have WPS Office installed on your machine.

STATUS: INVESTIGATING

Microsoft is aware of and investigating the issue. We will provide an update as soon as available. For the most recent information on this issue, go to Errors loading Excel Solver add-in.

Last Updated: November 14, 2017

ISSUE

You may have problems closing a workbook in protected view when the Excel file name contains square brackets (e.g., Book1[1234].xlsx).

STATUS: FIXED

This issue is fixed in Monthly Channel Version 1708 (8431.2110). To get the latest update immediately, open Excel and choose File > Account > Update Options > Update Now. For the most recent information on this issue, go to Cannot close Excel file when file name contains brackets.

Last updated: November 1, 2017

ISSUE

When you click Insert > Object > Create from file and then click the Browse button, Excel 2016 may crash. It seems this issue impacts these builds: Monthly Channel Version 1709 (8528.****) or Semi-Annual Channel Version 1708 (8431.****).

STATUS: WORKAROUND

For the most recent information on this issue, go to Excel may crash when you try to embed an object into a worksheet.

Last updated: October 11, 2017

ISSUE

If you use a button in a worksheet to start a macro and later close this workbook, subsequent attempts to calculate user-defined functions provided by an XLL add-in might crash.

This issue impacts Excel 2016 in Version 1608 (Build 7301.xxxx).

STATUS: FIXED

This issue is now fixed in Version 1708 (8431.2017). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Last updated: Sep 18, 2017

ISSUE

You may experience Excel freezing or crashing after attempting to publish a workbook as a web page using File > Save As > Browse > Save as Type: Web Page (*htm, *.html).

This issue impacts Excel 2016 in Version 1707 (Build 8326.xxxx).

STATUS: FIXED

This issue is now fixed in Version 1708 (8431.2079). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Issues affecting Excel features and add-ins

Last updated: November 7, 2017

ISSUE

When you double-click or choose the "new" option on a template file (.xlt, .xltx, .xltm) in Excel 2016, Excel opens two identical copies of the file.

STATUS: WORKAROUND

For the most recent information on this issue, go to Creating a new Excel file from a template opens the file twice.

Last updated: November 7, 2017

ISSUE

When you try to open a file in Excel, the file doesn't open but the Excel application does.

This can happen if the Show the Start screen when this application starts option is unchecked in Excel.

STATUS: WORKAROUND

For the most recent information on this issue, go to Excel file doesn't open after unchecking the option to show start screen.

Last Updated: November 02, 2017

ISSUE

Some devices may experience the cursor flickering when you open an Excel workbook and move over workbook cells after updating to the Windows 10 Fall Creators Update.

STATUS: INVESTIGATING

Microsoft is aware of and investigating the issue. We will provide an update to this forum as soon as available.

Last updated: October 26, 2017

ISSUE

Nothing happens when you check the option to resize shape to fit text.

STATUS: FIXED

This issue is now fixed in Monthly Channel Version 1709 (8528.2147). To get the update immediately open Excel 2016 and choose File > Account > Update Options > Update Now.

Last updated: October 13, 2017

ISSUE

When using the trial version of Office 365, every time you open an Office file, the latest version of the application gets automatically set as the default application for Word, Excel, or PowerPoint in all versions of Windows. For example, if you have Excel 2013 installed and are also running Office 365 trial version, then the workbook will open in Excel 2016.

STATUS: WORKAROUND

We recommend using Office365 for the latest features. However, you may uninstall the trial version so that we open files with the version of Excel you installed.

Last updated: November 14, 2017

ISSUE

When opening a file in Excel 2016 that contains multiple types of text formatting within the same cell, the formatting may be lost. Examples include having some rich text bolded and others in the same cell not bolded, or having different font colors for different characters within the same cell, such as the example below.

Using Rich Text font for multiple types of text formatting

STATUS: FIXED

This issue is fixed in Version 1708 (8431.2109). To get the latest update immediately, open Excel and choose File > Account > Update Options > Update Now. For the most recent information on this issue, go to Font formatting is lost when using rich text in Excel 2016.

Last updated: October 11, 2017

ISSUE

When using the CTRL+H keyboard shortcut or the Replace button on the ribbon, the Find and Replace dialog box displays the Find tab instead of the Replace tab. This issue impacts Version 1708 (Build 8420.xxxx).

Replace command on the Ribbon

STATUS: FIXED

This issue is now fixed in Version 1708 (8431.2094). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Last updated: September 29, 2017

ISSUE

When in Page Layout view, applying a fill formatting such as a pattern style to a cell or table does not render correctly after adding a header or a footer to the spreadsheet. You may see a black background or other formatting issues.

This issue impacts Version 1708 (Build 8431.2079).

STATUS: FIXED

This issue is now fixed in Version 1708 (Build 8431.2094). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Last updated: November 14, 2017

ISSUE

You receive an error when saving a workbook after inserting a chart in an existing workbook (previously saved) or copying values from an existing workbook.

Errors were detected while saving <workbook name>. Microsoft Excel may be able to save the file by removing or repairing some features. To make repairs in a new file, click Continue. To cancel saving the file, click Cancel.

If you click Continue, you get the following error:

Excel encountered errors during save. However, Excel was able to minimally save your file to <file name>.

This issue impacts Version 1707 (8326.2086) and later, and also only occurs with files that are stored locally, such as on the desktop. This problem does not occur if you manually enter values or insert a chart in a newly created workbook.

STATUS: FIXED

This issue is now fixed in Version 1708 (8431.2109). To get the latest update immediately, open Excel and choose File > Account > Update Options > Update Now. For the most recent information on this issue, go to Unable to save a workbook after inserting a chart in an existing workbook.

Last updated: September 29, 2017

ISSUE

AutoSave is no longer available or appearing in the Office toolbar in Office 2016 Version 1707 (Build 8326.2058) or higher.

STATUS: PARTIALLY FIXED

For Excel: This issue is now fixed in Version 1708 (Build 8431.2094). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

For Word: We are working on a releasing the fix soon. Thanks for your patience.

Last updated: September 29, 2017

ISSUE

After opening a file saved in OneDrive, OneDrive for Business, or SharePoint that is synced using a sync client, you may experience that the AutoSave is incorrectly disabled or greyed out. Hovering over the AutoSave toggle, the tool tip will prompt you with the following message:

AutoSave Not Available. This file location doesn't support AutoSave. Save to OneDrive or SharePoint Online if you want to use AutoSave.

AutoSave Not Available notification

This issue impacts the Office 2016 August 2017 update, Version 1708 (Build 8431.2079) and later for customers on the current channel (CC). Coauthoring and autosave are not yet supported for customers who are on the FRDC or SA (semi-annual) release channel. 

STATUS: FIXED

This issue is now fixed in Version 1708 (Build 8431.2094) for current channel (CC) customers. To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

If you are continuing to experience or have not updated yet, you can use the following workaround:

  • Open the Office app, click on File > Open and navigate to the server location (OneDrive or SharePoint).

  • Using a web browser, open the file directly from SharePoint or OneDrive where the file is stored.

Note - Coauthoring and autosave are not yet supported for customers who are on the FRDC or SA (semi-annual) release channel. These features are only available for customers on the current channel (CC). 

Last updated: Sep 14, 2017

ISSUE

After installing the September 12, 2017 update for Excel 2016 (KB4011050), dark borders may appear around rows or cells in Excel spreadsheets when you enter text.

Dark borders around cells when typing after installing KB4011050

STATUS: FIXED

This issue is now fixed in the KB4011165 update, released on September 12, 2017. If you have KB 4011050 installed, you do not need to uninstall this before installing KB4011165.

Last updated: September 18, 2017

ISSUE

When using Office 2016 apps and opening, editing, or saving Word files stored in OneDrive, you may be prompted to login with the following message: "Tell us the account you want to open _vti_rpc."

Login prompt to open _vti_rpc

STATUS: FIXED

This issue is now fixed in Version 1708 (8431.2079). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Last updated: August 16, 2017

ISSUE

When opening Office 2016 files, you may experience files are opening as read-only unexpectedly. This issue most commonly impacts Excel and Word in Version 1706 (Build 8229.2045) or later. Sometimes this issue manifests after you attempt to sync a document that requires check-in on OneDrive. Upon opening the file in Word or Excel, the file opens as read only.

STATUS: WORKAROUND

Our engineering team is actively fixing this issue. In the meantime, please refer to this article for workaround.

Need more help troubleshooting? 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.

Last updated: August 28, 2017

ISSUE

After updating to the August 1, 2017 update for Office 2016 (KB 4011051), clicking a hyperlink in an Excel workbook that points to another Excel workbook no longer works and you might receive a hyperlink warning message. You may also experience issues accessing WMI programmatically from Excel and Word.

STATUS: FIXED

This issue is now fixed. Please manually install the August 22, 2017 update for Office 2016 (KB 4011093). This KB 4011093 will be available as an automatic update and for those using Windows Server Update Services (WSUS) in the next monthly update for Office.

Last updated: September 27, 2017

ISSUE

When inserting an icon or a picture via Insert > Icons or Insert > Pictures, you receive the following error message:

An error occurred while importing this file. http://hubblecontent.osi.office.net/ContentSVC/Content/Download?provider=MicrosoftIcon&FileName=[icon].svg

STATUS: WORKAROUND

As a workaround you can do the following:

  1. Open Internet Explorer.

  2. Click on the Settings icon and then click Internet Options.

  3. Choose the Advanced tab and then find the Security section.

  4. Uncheck the option Do not save encrypted pages to disk.

Last updated: September 14, 2017

ISSUE

When using Excel 2016, the AutoFilter drop-down is not showing all available checkboxes. This happens when the number of rows exceeds 10,000. Other symptoms may occur as well. For example, the checkboxes may not be clickable, or the filtered result may not return expected results.

STATUS: FIXED

This issue is now fixed in Version 1707 (8326.2073) or later. To get the update immediately, open Excel and choose File > Account > Update Options > Update Now.

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 on Windows forum for personal, home, or university users
Office 365 community forum for business users

Chat

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

In Office 2016 on Windows 10, open an Office app, and click File > 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.

Connect with an expert
Contact us
Expand your skills
Explore training

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.

×