Share via

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

    600+ people found this answer helpful.
    0 comments
Answer accepted by question author
  1. 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]

    100+ people found this answer helpful.
    0 comments

90 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-02-21T20:13:40+00:00

    Its an known issue that excel cannot open new instance when ever you open file or excel application in windows vista\7.

    Only work around is start> all programs> MS office> excel

    No of times you open or launch app like this will open an new instance of excel.

    The suggestion given by RON AT BUY is for windows XP and the file types feature was removed from windows vista on wards.

    Keep Eye on your TIME, Not on your WATCH!

    If solution has resolved your issue(s), please mark it asPropose as Answerto let others know the solution that worked for you

    Please click on the “Vote as Helpful" button:)

    10 people found this answer helpful.
    0 comments
  2. Anonymous
    2012-05-08T21:02:11+00:00

    For Windows Vista or 7 to open a new instance of Excel try:

    You will need to make some new registry entries.  Before you do this, I highly recommend you backup your registry.  Changing the wrong thing in your registry can cause major issues with your computer.  However if you follow these instructions you should be fine.  Just to clarify if you wreck your system I take no responsibility.

    You need to open your Registry Editor

    Click on the Start button ( windows Orb)

    Directly above the circle button you will see a text box that says

    "Search Programs and Files"

    Inside this you need to type "regedit" without the double quotes, and press "ENTER"

    Next you need to navigate to the following registry entry

    HKEY_CLASSES_ROOT => Excel.Sheet.8 => Shell => Open => Command

    The (default) value will be something like this:

    "C:Program Files (x86)Microsoft OfficeOffice12EXCEL.EXE" /e

    And you'll want to append a "%1" to the end of that, making it:

    "C:Program Files (x86)Microsoft OfficeOffice12EXCEL.EXE" /e "%1"

    Next, you'll want to rename the command key, which is right below the (Default) key, to command2 or something else.

    Next you'll need to rename the DDE exec key here to DDEexec2 or something else:

    HKEY_CLASSES_ROOT => Excel.Sheet.8 => Shell => Open => ddeexec

    This will make the change for the Excel 97-2003 file type.

    If you want to do the same thing for Excel 2007 files, you'll need to make the changes to the HKEY_CLASSES_ROOT => Excel.Sheet.12 key.

    4 people found this answer helpful.
    0 comments