Solved

Open Excel 2003 in multiple windows on Windows7

Posted on 2011-09-26
10
302 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
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!

 

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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

705 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