Open an Excel document in separate windows or Excel instances

Hi,

How can we click on an existing Excel workbook and  have it open in a separate Excel instance?
(we found File >> Options >> Advanced >> General >> Check the box "Ignore other applications that use 'Dynamic Data Exchange (DDE)'", but when done, it always open an empty Excel with  no workbook content or blank workbook)
rayluvsAsked:
Who is Participating?
 
KimputerConnect With a Mentor Commented:
Add these registry entries (save as .reg, run it as admin, or import it):
Adjust as needed (for example, Office version and/or file path can be different)

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8\shell\Open]
@="&Open"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open]
@="&Open"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8\shell\OpenAsReadOnly]
@="&OpenAsReadOnly"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8\shell\OpenAsReadOnly\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\OpenAsReadOnly]
@="&OpenAsReadOnly"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12\shell\OpenAsReadOnly\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""

Open in new window

0
 
rayluvsAuthor Commented:
I have excel 2010, does this fix works for 2010?
0
 
KimputerCommented:
Yes, if you have 2010 32 bits, no editing needs to be done.
Registry sometimes needs to be re-applied due to Office updates sometimes overwriting it.
0
 
rayluvsAuthor Commented:
Thanx! Didn't see your entry.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.