Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 Win7 Open Multiple Windows

11 Oct 2010   #1
kentonj123

Windows 7 Enterprise
 
 
Excel 2010 Win7 Open Multiple Windows

I was searching for a way to open multiple windows in Excel every time I double clicked on an Xls or Xlsx file. I looked and found some solutions for 2007 and prior versions however I did not find any solutions for the Win7 Excel 2010 environment.

(I did find a way to do it by changing a fix for Win7 Excel 2007. Please let me know if it helps or if there is a different/better way to fix.)

Works for
Excel 2010 & Win7 (could work for 07 not tested)
------------------------------------------------------------------------
Open Registry Editor ver 6.1

-Go to Branch:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command

(Note: it doesn't matter what is listed under default)

-Change the value command and under data remove /dde (or /e) and add after existing string the following code below

/p "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" /e "%1"

(Note: /p switch will ignore the (default) open settings)

-Go to Branch:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec

-Rename ddeexec2

(compare to screen shot)
Excel 2010 Win7 Registry.jpg

Hope that helps users with Win7 Excel 2010.
-Kenton




Attached Thumbnails
-excel-2010-win7-registry.jpg  
My System SpecsSystem Spec
.
12 Oct 2010   #2
kentonj123

Windows 7 Enterprise
 
 

-Similar solution to above as a .reg file: Copy the following into a .txt file, then rename as a .reg file and save. Run as an administrator. You will need to replace the <Hexidecimal value> with the value specific to your install. Easy way to do that is to export your current key value.
------------------------------------------------------------------------------------

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""
"command"=hex(7):<Hexidecimal value>

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec]
@="[open(\"%1\")]"

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec\application]
@="Excel"

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec\topic]
@="system"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2]
@="[open(\"%1\")]"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2\application]
@="Excel"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2\topic]
@="system"

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""
"command"=hex(7):<Hexidecimal value>

[-HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec]
@="[open(\"%1\")]"

[-HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec\application]
@="Excel"

[-HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec\topic]
@="system"

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec2]
@="[open(\"%1\")]"

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec2\application]
@="Excel"

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec2\topic]
@="system"
My System SpecsSystem Spec
04 Apr 2012   #3
maw74656

Win7 Pro 64-bit
 
 
Worked but now have problem

So I used this registry hack, and I can now open excel files in separate windows. But when I do that, the windows are blank. Any ideas on why/how to correct?

I made the .reg file as described.
My System SpecsSystem Spec
.

04 Apr 2012   #4
maw74656

Win7 Pro 64-bit
 
 
figured it out

After I applied the registry hack, I needed to change the Excel.Sheet.8\Shell\Command\command to add the [/p "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" /e "%1"], then it works perfect!
My System SpecsSystem Spec
04 Apr 2012   #5
kentonj123

Windows 7 Enterprise
 
 

Perfect.
My System SpecsSystem Spec
04 Apr 2012   #6
maw74656

Win7 Pro 64-bit
 
 

So, [/p "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" /e "%1"] should have been added to the .reg file after the Hexadecimal value?
My System SpecsSystem Spec
04 Apr 2012   #7
kentonj123

Windows 7 Enterprise
 
 

/p will ingore the default open settings.

Depends on the enviroment. I'm deploying Win7 64bit and office 2010 32bit SBE. I had the note about the /p from our prior image with 2007 32bit. (we do not use 64bit office due to a plug in compatibility issue)

What is your O/S and Office version?
My System SpecsSystem Spec
04 Apr 2012   #8
maw74656

Win7 Pro 64-bit
 
 

Win7 Pro 64-bit, Office 2010 32-bit. I got it working (also modified it to work with .csv files opened in Excel), but I'm just thinking about how to flesh out the .reg file for sharing with other users here.
My System SpecsSystem Spec
04 Apr 2012   #9
kentonj123

Windows 7 Enterprise
 
 

Same enviroment... odd. Do you use a group policy?

I stopped using a .reg file and now update it by a scripting program. I check for the entry on boot before replacing it. (Windows updates will undo the change)

The command is as shown and works for me.
"C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" /e "%1"


Attached Thumbnails
-4-4-2012-11-57-09-am.jpg  
My System SpecsSystem Spec
04 Apr 2012   #10
strollin

W7 Ult desktop, W8.1 laptop, W10 laptop, W8.1 tablet
 
 

Quote   Quote: Originally Posted by kentonj123 View Post
I was searching for a way to open multiple windows in Excel every time I double clicked on an Xls or Xlsx file. ...
-Kenton
I'm curious, why would you want to open multiple windows whenever you double-click on an xls/xlsx file?
My System SpecsSystem Spec
Reply

 Excel 2010 Win7 Open Multiple Windows




Thread Tools





Similar help and support threads
Thread Forum
How do I open multiple Excel 2007 files in separate windows?
Hey, I want to open multiple Excel 2007 files in separate windows because I have 2 separate monitors. This works with for example Word (just double click on two different word files) but not with Excel. I read some work-around saying "open the first excel file by double clicking, then open an...
Microsoft Office
How to open 2 excel files side by side in Office 2010?
How can I open 2 excel files side by side in Office 2010?
Microsoft Office
Office 2010 Pro Plus Win7 x 64 Excel reconfigures Office 2010
It seems that there may be a problem in Office 2010. I just installed it to the standard MS default/recommended settings .........all looked good...used Word great..until I use Excel and each time I try to use excel it sets off an 'Office Configuration' screen which I can not stop..it take a few...
Microsoft Office
Can't open Excel 2010 files for some reason?
I am having problems trying to open Excel files by double clicking them for some strange reason. If I create an Excel file then save it for some bizzare reason it won't then open again by double clicking it. I have tried to go into the choose default programs but I can't find Excel 2010...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 22:41.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App