Open each spreadsheet in a new instance of Excel 2010

Anonymous
2011-02-18T11:48:00+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments
Answer accepted by question author
Anonymous
2012-02-08T11:42:24+00:00

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

Was this answer helpful?

600+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2011-02-18T17:12:59+00:00

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]

Was this answer helpful?

100+ people found this answer helpful.
0 comments

90 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2016-09-22T10:45:38+00:00

    For Excel 2010 & Windows 10 this PowerShell script works:

    $BranchArray = "Excel.CSV","Excel.Macrosheet","Excel.OpenDocumentSpreadsheet.12","Excel.Sheet.8","Excel.Sheet.12","Excel.SheetBinaryMacroEnabled.12","Excel.SheetMacroEnabled.12"

    ForEach ($Branch in $BranchArray){

    $TempValue = (Get-ItemProperty -Path "Registry::HKCR$Branch\shell\Open\command" -Name '(default)').'(default)'

    Set-ItemProperty -Path "Registry::HKCR$Branch\shell\Open\command" -Name '(default)' -Value $TempValue' "%1"'

    Rename-ItemProperty -Path "Registry::HKCR$Branch\shell\Open\command" -Name 'command' -NewName 'command2'

    Rename-Item -Path "Registry::HKCR$Branch\shell\Open\ddeexec" -NewName 'ddeexec2'

    }

    For revert changes:

    $BranchArray = "Excel.CSV","Excel.Macrosheet","Excel.OpenDocumentSpreadsheet.12","Excel.Sheet.8","Excel.Sheet.12","Excel.SheetBinaryMacroEnabled.12","Excel.SheetMacroEnabled.12"

    ForEach ($Branch in $BranchArray){

    $TempValue = (Get-ItemProperty -Path "Registry::HKCR$Branch\shell\Open\command" -Name '(default)').'(default)' -replace ' "%1"'

    Set-ItemProperty -Path "Registry::HKCR$Branch\shell\Open\command" -Name '(default)' -Value $TempValue

    Rename-ItemProperty -Path "Registry::HKCR$Branch\shell\Open\command" -Name 'command2' -NewName 'command'

    Rename-Item -Path "Registry::HKCR$Branch\shell\Open\ddeexec2" -NewName 'ddeexec'

    }

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-10-21T20:52:27+00:00

    Skip all the other helpful hints and use this simple one. It works perfectly without all the editing etc. of the other answers.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-11-02T13:49:58+00:00

    This does not work for Excel 2010. You will receive an error and be unable to open the file. Follow HammernNail directions to resolve properly.

    Relating to Windows 7 Professional and Excel 2010 Pro Plus

    Was this answer helpful?

    0 comments