?
Solved

Open Excel 2003 in multiple windows on Windows7

Posted on 2011-09-26
10
Medium Priority
?
325 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

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 2000 total points
ID: 36600168
0
 
LVL 50

Expert Comment

by:jcimarron
ID: 36600301
0
 
LVL 33

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

764 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