In Microsoft Excel 2013 and later versions, when you open multiple spreadsheets, they all open in the same instance of Excel. However, in some situations, such as when you're working with large Excel spreadsheets, you may want to open each one in a new instance. This article explains how to do that by configuring a registry key.
Note This method works only when you use the Excel icon to open the application. If you use File Open within the Excel application or double-click a file in Windows Explorer, the files will still open in the same instance as designed.
By opening each spreadsheet in its own instance, the spreadsheet has a dedicated 2 gigabytes (GB) of memory to use. This is important if you are experiencing out-of-memory issues in a 32-bit version of Excel.
Note If you are using the Large Address Aware option (see the "More Information" section), this limit may be increased.
To change the default setting, install the latest version of Office (build numbers referenced in the following table), and then add the key to the registry. The versions of Office that have the update include the following:
Important Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.
Exit all instances of Excel.
Start Registry Editor:
In Windows 10, click Start, type regedit in the Search box, and then select regedit.exe in the search results.
In Windows 8 or Windows 8.1, move the pointer to the upper-right corner, select Search, enter regedit in the search box, and then select regedit.exe in the search results.
Locate and select the following registry subkey:
On the Edit menu, point to New, and then select DWORD Value.
Enter DisableMergeInstance, and then press Enter.
In the Details pane, press and hold (or right-click) DisableMergeInstance, and then select Modify.
In the Value data box, enter 1, and then click OK.
32-bit versions of Excel 2016 can take advantage of the Large Address Aware (LAA) functionality after installation of the May 3, 2016, update for Outlook 2013 (KB3115031), build 16.0.6868.2060 for O365 Current Channel subscribers. This change lets 32-bit installations of Excel 2016 consume double the memory when users work on a 64-bit Windows OS. The system provides this capability by increasing the user mode virtual memory from 2 GB to 4 GB. This change provides 50-percent more memory (for example, from 2 GB to 3 GB) when users work on a 32-bit system. For more information about LAA, see Large Address Aware capability change for Excel.