Share via


Excel disablemergeinstance issues

Question

Monday, September 23, 2019 3:35 PM

We used to use Office 365 Excel 1803 with the disablemergeinstance registry key set as per this article, and it worked fine.

https://support.microsoft.com/en-ca/help/3165211/how-to-force-excel-to-open-in-a-new-instance-by-default

Since upgrading to 1902 it now does not function.  Tried on 

Anyone know if there is another regedit to use?  The alternatives (VBA, holding ALT, using /x) are cumbersome to get users to do, and the /x is annoying when there are personal shortcuts to Excel all over the place.

All replies (4)

Tuesday, September 24, 2019 6:35 AM âś…Answered | 1 vote

Hi,

Please try this medthod:

1. Press Win+R open Run dialog box- enter regedit and open Registry Editor:

2. Go to HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command - change the default value to "C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE" "%1"/x - rename the ddeexec key to ddeexec2:

3. The same method for Computer\HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command:

Please try this method and check if this will help you.

Regards,

Emi Zhang

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.


Monday, September 23, 2019 3:58 PM

Forgot to mention I'm on 16.0.11328.20420 but other 1902 versions had this issue, too.


Thursday, September 26, 2019 8:59 AM

Hi, 

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Regards,

Emi Zhang


Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.


Tuesday, October 1, 2019 2:56 PM

Seems to do the trick, thanks.