• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1874
  • Last Modified:

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

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
symigeek
Asked:
symigeek
2 Solutions
 
RickCommented:
Double-click your Excel icon and open one file.
Minimize it, double-click your Excel icon again and open the other file.
0
 
RickCommented:
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
 
OrcaKnightCommented:
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
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!

 
amateusnCommented:
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
 
moon_blue69Commented:
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
 
symigeekAuthor Commented:
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
 
Van_MCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now