Update 8/9/2016: Excel Workbooks may not open after installing MS16-088
UPDATE: This issue is resolved, scroll to the bottom to see the Resolution Section in todays update.
The Excel team has made a change in the behavior of certain file types to increase security. This change came in the security updates KB3115262, KB3170008, and KB3115322. Previously, when you tried to open an HTML or XLA file with an .XLS file extension from an untrusted location, Excel would warn about the mismatch between the file extension and content, but would still open the workbook without Protected View security. After the security updates Excel no longer will open the workbook because these files are not compatible with Protected View and there is no warning or other indication it was not opened. We apologize that Excel is showing a blank screen instead of a more helpful error message with information about what to do next.
We have a few options for workarounds. These are in order from safest to riskiest. While some people in the forums have suggested rolling back the security patch, we do not recommend that option as it can leave you open to other current and future threats.
- The best option is to move away from using HTML wrapped as .xls. If you use native formats (e.g. xls, xlsx, xlsb) which will open in protected view when untrusted, this will provide some level of protection from the documents being opened.
- You can unblock access for individual files you know are safe. To do this:
- Right click on the file and choose Properties
- On the General tab, click Unblock
- Click OK
- You can make use of existing Trusted Locations capabilities in Excel 2010, 2013, and 2016 via File -> options -> Trust Center -> Trust Center Settings -> Trusted Locations.
- You can save the web html file to a trusted location on the local machine (Excel comes with a set of default trust locations). If you do not see the local folder location you trust for these files, then press “Add new location…” button and add it in the Trusted Location dialog. If the HTML document is in a trusted location the KB fix is not applied (e.g. the unsafe HTML file is not blocked).
- This approach may unblock you, but it carries some risk as files of any file type in Trusted Locations are fully trusted. If an attacker can drop files into the trusted location they can easily exploit users who open such documents. Be especially cautious when specifying a custom folder as a trusted location.
Update 7/28/2016
Update: Our dev team is working on options to preserve security and assist customers with their workflow. Currently we do not have any further workarounds.
Additional background: The security update changed how Excel handles documents that are opened from untrusted locations (such the Internet zone) which are not supported in Protected View, such as HTML/XML/XLA files. Opening them without Protected View has led to a security vulnerability, and therefore files open from such locations are now blocked. We realize this breaks compatibility with some existing solutions, and are working on getting these file types supported with Protected View. Until that happens, users will need to manually trust the file before they open them in Excel, as demonstrated in one of the workaround suggestions. Excel can still open these files without an issue if they are trusted.
We strongly recommend against removing the security update. It will leave your systems vulnerable. More information is located here: https://technet.microsoft.com/library/security/MS16-088?f=255&MSPPError=-2147217396. Specifically, the section regarding "Microsoft Office Security Feature Bypass Vulnerability – CVE-2016-3279".
Additional information on implementing workaround options, by product version:
Office 2016
Here is information on Office Trusted Locations
https://technet.microsoft.com/en-us/library/cc179039(v=office.16).aspx
and information on Protected View settings
https://technet.microsoft.com/en-us/library/ee857087(v=office.16).aspx
Office 2013
Here is information on Office Trusted Locations
https://technet.microsoft.com/en-us/library/cc179039(v=office.15).aspx and information on Protected View settings
https://technet.microsoft.com/en-us/library/ee857087(v=office.15).aspx
Office 2010
Here is information on Office Trusted Locations
https://technet.microsoft.com/en-us/library/cc179039(v=office.14).aspx
and information on Protected View settings
https://technet.microsoft.com/en-us/library/ee857087(v=office.14).aspx
Update 8/9/2016
Resolution
Install the update for your version of Office.
- Office 365 subscription (Click-to-Run)—install the latest updates (this includes, Current Channel, First Release Deferred Channel and Deferred Channel)
- Installer version (MSI)—To get the fix today, use the links in the KB for your version of Office to download the update from the Download Center. The updates will also publish to Windows Update/WSUS service next week where they will be updated automatically based on the Windows Update settings.
- Office 2016: https://support.microsoft.com/kb/3115438
- Office 2013: https://support.microsoft.com/kb/3115455
- Office 2010: https://support.microsoft.com/kb/3115476
Comments
- Anonymous
July 27, 2016
Is it possible to set our local web server as a trusted location in Office? - Anonymous
July 28, 2016
Any updates on the "more permanent solution"? - Anonymous
July 29, 2016
The comment has been removed - Anonymous
July 30, 2016
The comment has been removed - Anonymous
August 01, 2016
Note that this also affects XLAM add-ins, which are not specifically identified above. This post contains very important information that users require to use Excel add-ins, and the workarounds described here should be more prominently featured in the general instructions for installing/loading add-ins until they are no longer necessary. - Anonymous
August 03, 2016
The option #3 workaround is not working. Here is what you said in this workaround:-----------------------------------------------------------------------------------------------------------------------------------------You can make use of existing Trusted Locations capabilities in Excel 2010, 2013, and 2016 via File -> options -> Trust Center -> Trust Center Settings -> Trusted Locations. You can save the web html file to a trusted location on the local machine (Excel comes with a set of default trust locations). If you do not see the local folder location you trust for these files, then press “Add new location…” button and add it in the Trusted Location dialog. If the HTML document is in a trusted location the KB fix is not applied (e.g. the unsafe HTML file is not blocked).------------------------------------------------------------------------------------------------------------------------------------------I followed these instructions for setting up a new trusted location, However, the HTML files in this location are still blocked. Is there something else that needs to be done, which is not stated in your instructions? - Anonymous
August 04, 2016
How can we uninstall these updates? They're not listed in the Installed Updates window on any machine that I've seen affected in my organization - even through a powershell window using WMIC to manually uninstall this specific KB... (3115262/3115272) - Anonymous
August 10, 2016
How can i code a solution when i export my excel document who is in html like this:header('Content-Encoding: UTF-8');header("Content-type:application/vnd.ms-excel;charset=UTF-8");header("Expires: 0");header("Cache-Control: must-revalidate, post-check=0, pre-check=0");header("Content-disposition: attachment; filename=myfile.xls");header("Pragma: no-cache");We must write the file with no html :(? - Anonymous
August 10, 2016
There is an open source code to convert HTML to Excel (xls 2003 format). You can install that and embed that service and improve on it if required as its opensource.https://github.com/ashwinrayaprolu1984/htmlwrapexcelconverter - Anonymous
August 10, 2016
This has been causing some serious conflicts with some web-based applications.Thank you very much.Ab DessoukiSystem Engineer | Microsoft TechnologiesIBM - Anonymous
August 11, 2016
Thanks for the Update 8/9/2016 in this article. I downloaded the fix, and Excel now opens up normally for HTML files with .XLS file extensions. - Anonymous
October 04, 2016
update - Anonymous
June 30, 2017
A related issue?We don't permanently load .xlam files as Add-Ins. They are opened as needed by clicking a button on custom toolbar.This has worked well for years until this week when ProPlus Version 1701 7766.2092 was pushed site-wide.Toolbar is created upon opening .xlam file. That's good. But when user closes all workbooks the newly created toolbar immediately disappears. So user's method of re-opening is also gone. No buttons. :(Putting .xlam file in Trusted Location does not fix this.Only manually installing the Add-In via File...Options...Add-Ins...Browse...checkbox, etc. will allow toolbar to stay in place after closing Excel. But that means loading .xlam in memory every time user is in Excel (not needed) and I have to either train users to manually install Add-In or change my deployment to automate Add-In install. As a dev I prefer having persistent toolbars but not persistent .xlam files that all load, all the time. Experimenting shows that as long as the toolbar is created while the .xlam is selected as an Enabled Add-In, the toolbar persists.So although possible to enable the add-in, create the toolbar, then disable the add-in...its not an optimal solution.Any guidance would be appreciated.