October 3, 2017, update for Excel 2016 (KB4011166)

This article describes update 4011166 for Microsoft Excel 2016 that was released on October 3, 2017. This update has a prerequisite.

Be aware that the update on the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2016. It doesn't apply to the Office 2016 Click-to-Run editions, such as Microsoft Office 365 Home. (How to determine?)

This update includes the following improvements and fixes the following issues:

• This update improves the system resource usage when you deal with Excel 2016 files that contain many formulas.
• This update improves several translations for the Danish and German versions of Excel 2016.
• This update also fixes the following issues:
  • An issue occurs in the column order in the OLE DB provider when you use a data model connection.
  • You see prompts to save each workbook that you have opened when you use PowerPivot in Excel 2016.
  • When you undo a measure creation in a PowerPivot table, Excel 2016 may crash.
  • When you rename a measure by using the measure editing dialog box of Excel in a PowerPivot table, the measure is broken, and Excel 2016 may crash.
  • Measure Editor displays red lines (an error state) for a pasted formula even when the formula is correct.
  • When you update a Project Online ODATA dataset, you receive the following error message:
    Object must implement IConvertible.
  • You cannot update a model query when the loaded table has a trailing white space in the column name.
  • Measure formatting is lost from the Pivot Table view when measures or more fields are added to the Pivot Table.
  • After you rename a measure from the PivotTable field list, you are unable to undo the operation.
  • The measure editing dialog box that's opened from the PivotTable field list doesn’t work correctly during typing.
  • After you work on PowerPivot windows for a while, Excel 2016 displays an error message, and Power Pivot windows cannot be opened.
  • When you add or update measures from Excel, you receive an unhandled exception if Power Pivot is in diagram view.
  • When you open a PowerPivot file, you receive the following error message:
    Excel found unreadable content.
  • Page breaks appear misaligned and the dragline continues to draw in wrong locations when you drag them in Page Break Preview view in Excel 2016.

  • After you install KB 4011050, black borders may appear around rows or cells in Excel spreadsheets when you enter text.

  • After you update a PowerPivot table, the formatting disappears.

Download Center

This update is available for manual download and installation from the Microsoft Download Center.

• Download update KB4011166 for 32-bit version of Excel 2016
• Download update KB4011166 for 64-bit version of Excel 2016

If you're not sure which platform (32-bit or 64-bit) you're running, see Am I running 32-bit or 64-bit Office? Additionally, see more information about how to download Microsoft support files.

Prerequisites

To apply this update, you must have Microsoft Excel 2016 installed.

Restart information

You may have to restart the computer after you install this update.

To determine whether your Office installation is Click-to-Run or MSI-based, follow these steps:

1. Start an Office 2016 application.
2. On the File menu, select Account.
3. For Office 2016 Click-to-Run installations, an Update Options item is displayed. For MSI-based installations, the Update Options item isn't displayed.

Office 2016 Click-to-Run installation	MSI-based Office 2016

How to uninstall this update

Windows 10

1. Go to Start, enter View Installed Updates in the Search Windows box, and then press Enter.
2. In the list of updates, locate and select KB4011166, and then select Uninstall.

Windows 8 and Windows 8.1

1. Swipe in from the right edge of the screen, and then select Search. If you're using a mouse, point to the lower-right corner of the screen, and then select Search.
2. Enter windows update, select Windows Update, and then select Installed Updates.
3. In the list of updates, locate and select KB4011166, and then select Uninstall.

Windows 7

1. Go to Start, enter Run, and then select Run.
2. Enter Appwiz.cpl, and then select OK.
3. Select View installed updates.
4. In the list of updates, locate and select KB4011166, and then select Uninstall.

Learn about the standard terminology that's used to describe Microsoft software updates. The Office System TechCenter contains the latest administrative updates and strategic deployment resources for all versions of Office.

The English (United States) version of this software update installs files that have the attributes that are listed in the following tables. The dates and the times for these files are listed in Coordinated Universal Time (UTC). The dates and the times for these files on your local computer are displayed in your local time together with your current daylight saving time (DST) bias. Additionally, the dates and the times may change when you perform certain operations on the files.

x64

x86