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

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 Windows 7 Excel 2010 environment.

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

Works for
Excel 2010 & Windows 7 (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 Windows 7 Excel 2010.
-Kenton



Attached Thumbnails
Excel 2010 Win7 Open Multiple Windows-excel-2010-win7-registry.jpg  
My System SpecsSystem Spec
.

12 Oct 2010   #2

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

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

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

Windows 7 Enterprise
 
 

Perfect.
My System SpecsSystem Spec
04 Apr 2012   #6

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

Windows 7 Enterprise
 
 

/p will ingore the default open settings.

Depends on the enviroment. I'm deploying Windows 7 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

Win7 Pro 64-bit
 
 

Windows 7 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

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
Excel 2010 Win7 Open Multiple Windows-4-4-2012-11-57-09-am.jpg  
My System SpecsSystem Spec
04 Apr 2012   #10

Win 7 Ultimate (64-bit), Win 8.1.1 (64-bit)
 
 

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




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 06:26 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33