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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-08-19T13:14:50+00:00

    The problem with the documented fix for this issue on the internet, is that by disabling DDE, you prevent other programs sending the data to excel (Excel actually opens, but ignores the Dynamic data exchange) and you end up with an empty instance of excel. Not to be beaten, I’ve come up with this method; it’s a little clunky, but it appears to work

    Using notepad, create a batch file called RunExcel.bat (remember to change the type from .txt to all files, or you will end up with a file called RunExcel.bat.txt)

    Insert the line

    "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Microsoft Excel 2010.lnk"/n %1

    Into the batch file. (Include the Speech marks)

    Save this batch file into somewhere easy to remember. (I’d avoid using the network drives)

    Now we need to make any request to run excel use the batch file instead of excel, we do this by changing the association for the excel file types.

    Start à Control Panel àDefault Programs à Associate a file type or protocol with a program.

    Scroll down to the excel extensions (.xls, .xlsx etc); select each one in turn and click the change program button. When the dialog appears, click the browse button and navigate to the RunExcel.Bat file created earlier. (Note, once you’ve associated the batch file once, it should appear in the ‘Other programs drop down’)

    That’s it. From now on when you open an excel document either from explorer or another program like outlook, each sheet will open in a new window.

    This could be a little slicker by making the RunExcel an exe, then you could change the icon so that it looks like the files will open with Excel. in addition you could prevent the pop-up window appearing by checking the exe to run minimised.

    Mike.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-06-21T21:09:00+00:00

    Excel 2010:

    From Excel "Options"> Advance Tap> Scroll to "Display"> and check "Show all windows in the task bar"

    by doing this, you will not affect the programs which using excel :)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2012-05-09T22:58:13+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

    This does not work, it generates a much described error that many users of 2010 have encountered when not seeking this functionality.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments