June 7, 2016, update for Excel 2013 (KB3115162)

Applies to: Microsoft Office 2010 Service Pack 2Excel 2010Office Home and Student 2013 RT

This article describes update KB3115162 for Microsoft Excel 2013, which was released on June 7, 2016. This update also applies to Office Home and Student 2013 RT. This update has a prerequisite.

Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2013. It doesn't apply to the Office 2013 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 except for connections to Analysis Services. See more information about the Power View roadmap.
  • 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 use the 32-bit version of Excel 2013 to process large 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 2013. See KB3160741 for more information.
    • When you scroll a worksheet in Excel 2013, text that's wrapped and centered across selection isn't displayed.
    • When you set the name of a range to a custom user-defined function name in Excel 2013, Excel 2013 crashes.

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. The updates in the Download Center can't be installed on Office Home and Student 2013 RT.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

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:
  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.

Restart information

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


To apply this update, you must have Microsoft Office 2013 Service Pack 1 installed.

More Information

To determine whether your Office installation is Click-to-Run or MSI-based, follow these steps:
  1. Start Microsoft Excel 2013.
  2. On the File menu, select Account.
  3. For Office 2013 Click-to-Run installations, an Update Options item is displayed. For MSI-based installations, the Update Options item isn't displayed.
Office 2013 Click-to-Run installationMSI-based Office 2013
The screenshot for Excel Click To Run The screenshot for Excel MSI


Learn about the standard terminology that Microsoft uses to describe 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.