June 7, 2016, update for Excel 2016 (KB3115139)

This article describes update KB3115139 for Microsoft Excel 2016, which was released on June 7, 2016. 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 deletes the Power View button from the Import Data dialog box. But this update doesn't apply for external connections to Analysis Services. See more information about the Power View roadmap.
  • This update changes the way temporary file names are generated for features such as opening read-only files from share folders, sending workbooks as email attachments, and interacting with shared workbooks. Therefore, more valid names for .tmp files can be generated, and more .tmp files can be opened before a duplicate name occurs.
  • This update includes the following fixes and improvements for the Power Pivot Add-in:
    • Deletes unsupported KPI icon sets from Power Pivot.
    • Renaming a measure in the PivotTable field list will apply that change to the name in Power Pivot.
    • Fixes issues that occur when you use the option to save password for connections to SQL Server from Power Pivot.
    • Fixes issues that occur when you import data into Power Pivot from Analysis Services.
    • Enables changes to the data type of a column after you rename the column in Power Pivot.
    • Fixes issues that occur when you use column sort or filter control in Power Pivot after you add a table to the data model.
    • Improves support for DAX formula auto-complete in right-to-left languages.
    • Fixes some Power Pivot help links that point to help topics in an incorrect language.
    • Fixes issues that might occur when you use unsupported Power Pivot KPI icon sets.
    • Fixes issues that might occur when you use copy or paste operation in Power Pivot on a measure that contains a KPI.
    • Fixes the issue of the display of field names in right-to-left languages in Power Pivot diagram view after you use the drag-and-drop operation.
    • Supports correct visualization based on data type of Power Pivot column that's created by Get & Transform queries.
    • Fixes some missing localization of strings in Power Pivot.
  • When you launch Excel by using the Excel icon, you can create a separate Excel.exe process.

    Note To enable this functionality, you need to follow the instructions in the "Registry information" section.
  • Fixes the following issues:
    • When you set the name of a range to a custom user-defined function name in Excel 2016, Excel 2016 crashes.
    • When you scroll a worksheet in Excel 2016, a text that's formatted with Wrap text and Center Across Selection isn't displayed.
    • The Workbook_BeforeClose event doesn't occur after the Cancel value is set to True.
    • When you use the 32-bit version of Excel 2016 to process large amounts of data in the 64-bit version of Windows, you receive the following error messages:
      Excel cannot complete this task with available resources. CHoose less data or close other applications. Continue without Undo.

      There isn't enough memory to complete this action.
      For example, this issue occurs when you update a large pivot table in the 32-bit version of Excel 2016. See KB3160741 for more information.
    • When you edit gradients and borders for conditional formatting rules in Excel 2016, Excel 2016 may crash.
    • When you copy some cells from Excel 2016 and paste them as a picture to other documents, the format of the picture is displayed incorrectly.

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.

Virus-scan claim

Update information

Registry information

Important
Follow the steps in this section carefully. Serious problems might occur if you change the registry incorrectly. Before you change it, back up the registry for restoration in case problems occur.


After you install this update, follow these steps to set a registry key so that the white space isn't trimmed after export.
  1. Exit all Microsoft Office applications.
  2. Start Registry Editor:
    • In Windows 10, go to Start, enter regedit in the Search Windows box, and then select regedit.exe in the search results.
    • In Windows 8 or Windows 8.1, if you're using a mouse, move it to the upper-right corner, go to Search, enter regedit in the search text box, and then select regedit.exe in the search results.
    • In Windows 7, go to Start, enter regedit in the Search programs and files text box, and then select regedit.exe in the search results.
  3. Locate and then select the following registry entry:
    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 DisableMergeInstance, and then press the Enter key.
  6. In the Details pane, press and hold (or right-click) DisableMergeInstance, and then select Modify.
  7. In the Value data box, enter 1, and then select OK.
  8. Exit Registry Editor.

Restart information

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

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

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. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
x64
x86
Properties

Article ID: 3115139 - Last Review: Jan 22, 2017 - Revision: 2

Excel 2016

Feedback