locked
Opening Excel in a Seperate instance RRS feed

  • Question

  • Hi There,

    In XP I could change the file association for Excel, to force it to open a new instance when I double click on a file. I can't find how to do this in Win7 and Office 2007. All I can do is choose a new program.

    Help! Thanks
    Iain
    • Moved by Carey FrischMVP Wednesday, October 14, 2009 1:38 PM Moved to relevant category (From:Windows 7 Miscellaneous)
    Wednesday, October 14, 2009 10:48 AM

Answers

  • Hi Dale,

    I'd forgotten about this post (went on holiday straight after), sorry.

    I found out how, you need to hack the registry as found here http://brett.batie.com/?p=85 :
    Delete the following lines in the registry (or rename):
    HKCR\Excel.Sheet.8\shell\Open\ddeexec
    HKCR\Excel.Sheet.12\shell\Open\ddeexec
    and change the below like shown:
    HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command
    C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e “%1″
    HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
    C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e “%1″

    Works just like in XP.

    Thanks!

    • Marked as answer by Iain Record Thursday, December 3, 2009 10:16 AM
    Thursday, December 3, 2009 10:15 AM

All replies

  • Hi,

    Based on test on our test machines, as a work around, you need to create a new program and open the file there for each excel file to display in seperate window. Or you can double click a excel file and minimize the window then double click another excel file. Though excel files are displayed inside the main excel window, we can view excel seperately by preview window or switching tabs. 
     
    BTW, it is recommended to involve Microsoft Office 2007 for help.

    Best Regards
    Dale

    • Marked as answer by Dale Qiao Wednesday, October 21, 2009 1:02 AM
    • Unmarked as answer by Iain Record Thursday, December 3, 2009 10:16 AM
    • Proposed as answer by Timothy Webb Thursday, March 18, 2010 11:52 PM
    Thursday, October 15, 2009 7:42 AM
  • Hi Dale,

    I'd forgotten about this post (went on holiday straight after), sorry.

    I found out how, you need to hack the registry as found here http://brett.batie.com/?p=85 :
    Delete the following lines in the registry (or rename):
    HKCR\Excel.Sheet.8\shell\Open\ddeexec
    HKCR\Excel.Sheet.12\shell\Open\ddeexec
    and change the below like shown:
    HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command
    C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e “%1″
    HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
    C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e “%1″

    Works just like in XP.

    Thanks!

    • Marked as answer by Iain Record Thursday, December 3, 2009 10:16 AM
    Thursday, December 3, 2009 10:15 AM
  • A working solution in Windows 7 and XP I have tested.

    This is my proposed solution. Click the below link for step by step instructions.

    Multiple Instances of Excel for all Versions including 2007

    Please post your feedback or reply on my blog if this solution works for you.

    Thank You

    Timothy Webb

    • Proposed as answer by Timothy Webb Thursday, March 18, 2010 11:55 PM
    Thursday, March 18, 2010 11:55 PM
  • Your blog post seems to have disappeared.

     

    Page not found

    Sorry, the page you were looking for in the blog The Technology Advocate does not exist.
    COuld you possible post your solution here or update the link?
    Tuesday, August 3, 2010 1:13 PM
  • If you delete the following lines, when opening a previously saved spreadsheet (example.xlsx), the operation completes as opening a (new spreadsheet.xlsx)

    Delete the following lines in the registry (or rename):
    HKCR\Excel.Sheet.8\shell\Open\ddeexec
    HKCR\Excel.Sheet.12\shell\Open\ddeexec

     

    Tuesday, January 11, 2011 5:52 AM