Solved

Open Excel 2003 in multiple windows on Windows7

Posted on 2011-09-26
10
284 Views
Last Modified: 2012-05-12
Can anyone help with this please?
I appreciate you can open 2 instances of excel by opening from the Excel icon from the taskbar but...
can you open 2 worksheets in seperate windows by double 2 excel files from the desktop?  They always open in the same window.

In XP you used to do this by adding the "%1" to the file association...
Please note this is Office2003 on Windows7
Thanks
0
Comment
Question by:buddles
10 Comments
 
LVL 20

Expert Comment

by:clarkscott
ID: 36599064
You must start Excel separately.
1.  You have 1 instance of Excel.
2.  Minimize the Entire Excel app, click on the Excel icon, - you know have a 2nd instance.

Scott C
0
 
LVL 5

Expert Comment

by:Kannan K
ID: 36599160
Hi,

By default in windows 7 you will get multiple window only. But windows 7 has cascading icons in single group. please refer the attached image.

KK, for your reference
0
 
LVL 23

Expert Comment

by:Danny Child
ID: 36599368
In Excel, go to the Tools menu... Options.. select the View tab.. and tick the box for Windows In Taskbar.
This should give you multiple instances.  
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:buddles
ID: 36599379
so is there no way of doing what I need?  Need to display 2 windows to compare on multiple screens side by side by opening files from desktop rather than opening excel first?
0
 

Author Comment

by:buddles
ID: 36599639
Thanks Dan for the suggestion but this is already ticked.
0
 
LVL 18

Accepted Solution

by:
centerv earned 500 total points
ID: 36600168
0
 
LVL 50

Expert Comment

by:jcimarron
ID: 36600301
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 36600595
If opening the files in the same window you can use the Arrange option to put them side by side for comparison. There is also the option for synchronised scrolling.

If not arranged side by side and the only two files open, you can use Ctrl + Tab to toggle between the two files; much as you would use Alt + Tab to toggle between the two instances.

Thanks
Rob H
0
 

Author Closing Comment

by:buddles
ID: 36708346
Thanks Centerv.  Exactly what I was looking for.  Suprised this solution is so hard to find.
0
 
LVL 18

Expert Comment

by:centerv
ID: 36709720
You're welcome.
Here's a recap from the link, should it go down.
Thanks to the poster.


open regedit
Next you need to navigate to the following registry entry
HKEY_CLASSES_ROOTExcel.Sheet.8shellOpencommand
The (default) value will be something like this:
"C:Program Files (x86)Microsoft OfficeOffice12EXCEL.EXE" /e
And you'll want to append a "%1" to the end of that, making it:
"C:Program Files (x86)Microsoft OfficeOffice12EXCEL.EXE" /e "%1"
Next you'll want to rename the command key, which is right below the (Default) key, to command2 or something else.
Next you'll need to rename the ddeexec key here to ddeexec2 or something else:
HKEY_CLASSES_ROOTExcel.Sheet.8shellOpenddeexec
This will make the change for the Excel 97-2003 filetype.
If youwant to do the same thing for Excel 2007 files, you'll need to make thechanges to the HKEY_CLASSES_ROOTExcel.Sheet.12 key.
Hopefully this helps everyone out.

0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question