April 4, 2017, update for Excel 2016 (KB3178719)

Applies to: Excel 2016

This article describes update KB3178719 for Microsoft Excel 2016, which was released on April 4, 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?)

Improvements and fixes


This update includes the following improvements and fixes:
  • When a workbook contains a slicer and other objects such as a smart art in Excel 2016, the slicer is not printed and is displayed as an empty box.
  • After you install this update, you can get the Permission object in VBA without admin permissions in Excel 2016.
  • When you try to scroll sheet tabs in a workbook that has a large number of sheets in Excel 2016, Excel 2016 may freeze.
  • Running VBA macros that involve hidden workbooks may be slower in Excel 2016.

    Note To fix this issue, follow the steps in the Registry Information section.
  • Translates the "Disable automatic grouping of Date/Time columns in PivotTables" checkbox in Excel 2016 Options into multiple languages.
  • This update adds some new Get & Transform features in Excel 2016. See KB3191838 for more information.
  • Fix an issue that occurs when you use Korean input method editor (IME) to rename tables in PowerPivot manager.
  • Whenyou try to recover documents in Excel 2016, the recover process fails and nothing happens.

How to download and install the update


Microsoft Update

Use Microsoft Update to automatically download and install the update.

Download Center

This update is also available for manual download and installation from the Microsoft Download Center.If you're not sure what 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.

Update information


Registry information

 
  1. Exit all Microsoft Office applications.
  2. Start Registry Editor:
    • In Windows 10, go to Start, enter regedit in the Search box, and then select regedit.exe in the search results.
    • In Windows 8 or Windows 8.1, move your mouse to the upper-right corner, select Search, enter regedit in the search text box, and then select regedit.exe in the search results.
    • In Windows 7, select Start, enter regedit in the Start Search box, and then select regedit.exe in the search results.
  3. Locate and then select the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
  4. On the Edit menu, point to New, and then select DWORD Value.
  5. Enter NoActivateHidden, and then press Enter.
  6. In the Details pane, press and hold (or right-click) NoActivateHidden, and then select Modify.
  7. In the Value data box, enter 1, and then select OK.
  8. Exit Registry Editor.

Prerequisite

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.

More information


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 installationMSI-based Office 2016
The screenshot for Word click to run The screenshot for Word MSI

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 KB3178719, 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 KB3178719, 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 KB3178719, and then select Uninstall.

References


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.

File information


The global version of this update has the file attributes (or later file attributes) that are listed in the following table. 

x86

x64