Solved

Open Excel 2003 in multiple windows on Windows7

Posted on 2011-09-26
10
295 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
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…

739 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