Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Opening two Excel files in two different windows (Excel 2010)

Posted on 2010-11-29
7
Medium Priority
?
1,865 Views
Last Modified: 2013-11-05
Hello,
I have been trying to get Excel to open files in two seperate windows and have not been able too.  We need to be able to not just compare two spreadsheets but be able to open them so that they can be moved around on the desktop.  This was possible in Excel 2003 and MS seems to have fixed something that wasn't broken. We are trying to do this on PC's that have a Windows 7 O/S.

Thanks,
 Joe
0
Comment
Question by:symigeek
[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
7 Comments
 
LVL 13

Expert Comment

by:Rick
ID: 34232696
Double-click your Excel icon and open one file.
Minimize it, double-click your Excel icon again and open the other file.
0
 
LVL 13

Accepted Solution

by:
Rick earned 750 total points
ID: 34232712
If you don't want to do that. Try this:

1. Open Excel
2. Click on the Office Button
3. Click Excel Options
4. Go to the Advanced section
5. Go to "Display" heading
6. Click "Show all windows in the Taskbar"
7. Close Excel
0
 
LVL 5

Assisted Solution

by:OrcaKnight
OrcaKnight earned 750 total points
ID: 34232724
You can open two Excel windows as separate panes by opening Excel itself twice, without opening a named spreadsheet beforehand. This should have two completely independant Excel sessions, and then you can open the two sheets you want to work on. Is that what you needed to do?
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!

 
LVL 3

Expert Comment

by:amateusn
ID: 34232726
If the answer above doesn't work, try to open one file, then go to File>New Document, and when it's opened go to File>Open.
0
 
LVL 10

Expert Comment

by:moon_blue69
ID: 34232746
Was this comment helpful?
Yes No
moon_blue69:
There is a setting you can enable within Excel 2007, similar to the option there was in 2003, but just a different location due to the changed GUI of course:

1. Open one instance of Excel 2007
2. Click on the Office Button (top left hand corner)
3. Click Excel Options
4. Go to the Advanced section on the left
5. Scroll down to the "Display" heading
6. Tick "Show all windows in the Taskbar"
7. Close Excel

Now whenever you open an Excel file it'll definitely open in a separate instance.

The following link will guide you if you are on office 2010

http://social.technet.microsoft.com/Forums/en-US/office2010/thread/749983b3-ba7e-49d3-99bf-f67d70245046
0
 

Author Closing Comment

by:symigeek
ID: 34233755
I found that in Windows 7 and Office 2010 you must "right-click" the icon on the task bar then click on "Microsoft Excel 2010" for the second session to open.  You can then proceed to open a second document.
0
 

Expert Comment

by:Van_M
ID: 36016516
http://blog.whitesites.com/Force-Windows-7-to-open-excel-documents-in-separate-windows__634014706378053750_blog.htm

This provides functionality really being looked for in all these workarounds.  Windows 7 & Excel 2010 don't play nice with some of these, but this registry manipuluation does the trick.
0

Featured Post

Industry Leaders: 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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
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…

715 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