+ Reply to Thread
Results 1 to 2 of 2

Open Excel in new window Excel version 2010

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    Thunder Bay, Ontario
    MS-Off Ver
    Excel 2016
    Posts
    24

    Open Excel in new window Excel version 2010

    I'm sorry if this is a duplicate post but I can only find solutions for other versions and it doesn't apply.

    I am working in Excel 2010. I would like excel to open each spreadsheet in its own instance and not within the same window.

    I have gone to: File/Options/Advanced/ checked "Ignore other applications that use Dynamic Data Exchange (DDE)"

    This works only if I keep all my spreadsheets open. Once I close them all and try to get back in I get the error "There was a problem sending the command to the program". It only allows me to open a blank new spreadsheet, not a previously saved one.

    How can I make excel open all my files in a new window when I double click them, and keep this setting?

    Thanks for any help!

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Open Excel in new window Excel version 2010

    You'll need to edit your registry to completely remove the DDE option.

    http://social.technet.microsoft.com/...pdeploylegacy/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hi, i'm almost completely new to Excel, i am using version 2010
    By jeffberrill in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-30-2013, 07:25 PM
  2. Default Fit To Selection for all Excel 2010 Version..
    By suryatry26 in forum Excel General
    Replies: 0
    Last Post: 07-15-2013, 05:47 AM
  3. How to open a xlsb format from 2010 version in Excel 2003 ?
    By nemo66ro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 01:25 PM
  4. Replies: 5
    Last Post: 05-10-2012, 03:43 AM
  5. Excel 2007 to 2010 version problem
    By Gundersen in forum Excel General
    Replies: 0
    Last Post: 03-31-2010, 09:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1