Solved

Open Excel 2003 in multiple windows on Windows7

Posted on 2011-09-26
10
277 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:Kannan253984
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:DanCh99
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
 

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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 18

Accepted Solution

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

Expert Comment

by:jcimarron
ID: 36600301
0
 
LVL 31

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now