+ Reply to Thread
Results 1 to 6 of 6

How to open workbooks in same instance of Excel 2007

  1. #1
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    How to open workbooks in same instance of Excel 2007

    Had to rebuild my PC's hard disk and reinstall software. Now, whenever I open another workbook via explorer double click, a new instance of Excel starts. If I open another workbook using Excel's menu open, then the workbook opens in the same instance. I've tried a 'Repair' of Office and resetting the default programs to Excel for all Excel related file extension types. Please help. Thanks.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to open workbooks in same instance of Excel 2007

    Excel Options > Advanced > General, untick Ignore other applications that use DDE
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    Re: How to open workbooks in same instance of Excel 2007

    Good try but that didn't work either. Thanks.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to open workbooks in same instance of Excel 2007

    You sure about that?

  5. #5
    Forum Contributor
    Join Date
    08-17-2009
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    106

    Re: How to open workbooks in same instance of Excel 2007

    I have a very similar issue now that I had windows XP upgraded to windows 7. The checking of ignore DDE works for the day. however when I reboot I can't open any excel files by clicking them. I can reset the option and everything works fine again except the new file always opens in the original instance of excel.

  6. #6
    Forum Contributor
    Join Date
    07-16-2007
    MS-Off Ver
    Excel 2003 and Excel 2016
    Posts
    178

    Re: How to open workbooks in same instance of Excel 2007

    Thanks, shg, but I am sure. I've closed all instances of Excel, started Excel, and made sure the box was unchecked. No change. I changed all of the default programs that have extensions related to Excel to point to the Excel.EXE file in the Office12 folder, but still no luck.

+ 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. Replies: 2
    Last Post: 11-08-2013, 10:50 AM
  2. Excel 2007 unable to "see" other open workbooks
    By ssu95bm in forum Excel General
    Replies: 9
    Last Post: 09-23-2011, 09:19 AM
  3. Open a New Instance of Excel On Top
    By c_leven3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2010, 11:26 AM
  4. Replies: 0
    Last Post: 11-08-2007, 04:18 AM
  5. Switching Between Open Workbooks in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 10-31-2007, 04:35 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