Description of the security update for Excel 2016: September 12, 2017

This security update contains improvements and fixes for the following nonsecurity issues:

• VBA code in Excel 2016 has worse performance than in Excel 2010.

• Assume that you run a macro to hide a shape in a worksheet in Excel 2016. After you copy cells that contain the invisible shape and paste to a Word document, the shape becomes visible.

• Improve the translation for the following in Excel 2016:

  • The description for the T function in German

  • Warning message when you delete a row in filtered table in Dutch

• When you drag an object from another application to a workbook in Excel 2016, the object is dropped at a different position.

• Add some Get $ Transform features in Excel 2016. See KB4011114 for more information.

• Excel 2016 may crash when filtering PivotTable in a workbook.

• Document Inspector seems to freeze when you open some files and then return to it.

• Excel 2016 may crash when you convert data model PivotTables to formulas and then undo the operation.

• The drill down of data model PivotTables doesn't include enough fields (foreign key should be included).

• The connection name of a data model that is created in Excel 2010 is changed in Excel 2016 before the data mode upgrade.

• Online Analytical Processing (OLAP) PivotTable field list is not updated after you create the first MDX calculated measure.

• When you undo a sheet-insertion operation for a PivotTable list formula in Excel 2016, Excel 2016 may crash.

• Power Pivot freezes when you delete a column from a data model.

• Excel crashes after you undo the change of the table style layout of a Pivot Table.

• When you select Summarize with PivotTable from the Tell Me drop-down list in Excel 2016, Excel 2016 may crash if the chart sheet is active.

• The drill down of Pivot Table does not generate the following error message:

  Members, tuples, or sets must use the same hierarchies in the function.

   

• You can't commit changes to the provider definitions of PowerPivot data.

• PowerPivot can't load the data model when you upgrade the data model in a workbook that is opened from SharePoint.

• You can't load tables in PowerPivot, and you experience an unhandled exception when the PowerPivot window is opened on a large display screen.

• When you try to create a new Pivot Table from the PowerPivot window, you receive the following error message:

  Exception has been thrown by the target of an invocation.

• The current selection is replaced by the table name after you change the PowerPivot window size.

• When you delete a sheet for the data model of PowerPivot in Excel 2016, Excel 2016 may crash.

• After you delete the data connection and then undo the operation, Excel 2016 freezes or crashes.

After this update is installed, black borders may appear around rows or cells in Microsoft Excel spreadsheets when you enter text. To fix this issue, install September 12, 2017, update for Excel 2016 (KB4011165).

Method 1: Microsoft Update

This update is available from Microsoft Update. When you turn on automatic updating, this update will be downloaded and installed automatically. For more information about how to get security updates automatically, see Windows Update: FAQ.

Method 2: Microsoft Update Catalog

To get the stand-alone package for this update, go to the Microsoft Update Catalog website.

Method 3: Microsoft Download Center

You can get the stand-alone update package through the Microsoft Download Center. Follow the installation instructions on the download page to install the update.

• Download the security update KB4011050 for the 32-bit version of Excel 2016
• Download the security update KB4011050 for the 64-bit version of Excel 2016

Security update deployment information

For deployment information about this update, see security update deployment information: September 12, 2017.

Security update replacement information

This security update replaces previously released security update KB3203477.

File hash information

File information