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

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

Update information

Registry informationImportant
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\15.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 informationYou may have to restart the computer after you install this update.

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

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

References

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.