This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How do I configure Excel to open a new instance of Excel each time I open an existing spreadsheet. I am sure I have done this once but I think network settings have removed this functionality. I am using Office 2010 on Vista.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
To resolve this, go to 'excel options' > click on the 'advanced' tab > scroll down to general > check the ignore other applications that use 'Dyanamic Data Exchange (DDE)'
excel 2007
This is a reply by Brian Tilman to a similar problem with 2007. I anticipate it will work with 2010 as well:
Open Windows Explorer and click Tools>Folder Options>File Types. Locate the XLSX file type and select it. Click Advanced. In the Actions pane, select Open and click Edit. Record what you see in the "Application used to perform action" and "DDE Message" fields because you'll need it if you ever want to restore the current behavior.
Remove the "/dde" from the end of the string in the "Application used..." field and insert "%1", being sure to include the quotes as well. Uncheck the "Use DDE" box. Click OK. Uncheck "Browse in same window" if you want Internet Explorer to open a spreadsheet in an Excel window instead of a browser window. Click OK, then OK. Double-clicking a worksheet should now create a separate Excel window.
Brian Tillman [MVP-Outlook]
The real answer is in: https://support.microsoft.com/en-us/kb/2636670 -- Don't bother with the non-answers on the first page. This is what you must do:
In regedit, go to HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open and to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open
In each of the above, you will see a Default and a Command string. At the end of the strings there is a "/e" or a "/dde". Replace these with ""%1"" (note that the %1 must have quotes around it in the string.)
Also you will find the folder ddeexec in Open. Rename them to ddeexec2.
Job done.
Hey Brom Nader.
you're quite aggressively commenting on a post and replies from 2011/2012.
The OS and office package have changed a lot since then.
can I suggest creating a new thread for your scenario and solution.
This is a reply by Brian Tilman to a similar problem with 2007. I anticipate it will work with 2010 as well:
Open Windows Explorer and click Tools>Folder Options>File Types. Locate the XLSX file type and select it. Click Advanced. In the Actions pane, select Open and click Edit. Record what you see in the "Application used to perform action" and "DDE Message" fields because you'll need it if you ever want to restore the current behavior.
Remove the "/dde" from the end of the string in the "Application used..." field and insert "%1", being sure to include the quotes as well. Uncheck the "Use DDE" box. Click OK. Uncheck "Browse in same window" if you want Internet Explorer to open a spreadsheet in an Excel window instead of a browser window. Click OK, then OK. Double-clicking a worksheet should now create a separate Excel window.
Brian Tillman [MVP-Outlook]
Does NOT work. Real answer is here:
This is the answer, ignore the other 2 answers, they don't work for W7.