Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: How do I open multiple Excel 2007 files in separate windows?

10 Jun 2010   #1
cyru11s

Windows 7
 
 
How do I open multiple Excel 2007 files in separate windows?

Hey,

I want to open multiple Excel 2007 files in separate windows because I have 2 separate monitors. This works with for example Word (just double click on two different word files) but not with Excel.
I read some work-around saying "open the first excel file by double clicking, then open an empty excel file via start button and then open the other file from within the new window."

But surely there is an easier way? For example setting folder options for Excel files?

I have Windows 7, 64-bit if that makes a difference.

Thanks


My System SpecsSystem Spec
.

10 Jun 2010   #2
JMH

Win 7 Ultimate 64-bit. SP1.
 
 

Quote   Quote: Originally Posted by cyru11s View Post
Hey,

I want to open multiple Excel 2007 files in separate windows because I have 2 separate monitors. This works with for example Word (just double click on two different word files) but not with Excel.
I read some work-around saying "open the first excel file by double clicking, then open an empty excel file via start button and then open the other file from within the new window."

But surely there is an easier way? For example setting folder options for Excel files?

I have Windows 7, 64-bit if that makes a difference.

Thanks
Hi cyru11s.
Is this link of any help to you?
How to manage multiple windows in Excel
My System SpecsSystem Spec
11 Jun 2010   #3
cyru11s

Windows 7
 
 

No it didn't.
Let me try again: I want to open FileA.xls in one instance of Excel and FileB.xls in another. Each of these instances has for example it's own toolbars.
Or if you open two different instances of word as I described in my earlier post and then go to the Windows Task Manager you see two different applications for Word running, but only one for Excel.
My System SpecsSystem Spec
.


11 Jun 2010   #4
WindowsStar

Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
 
 

Quote   Quote: Originally Posted by cyru11s View Post
No it didn't.
Let me try again: I want to open FileA.xls in one instance of Excel and FileB.xls in another. Each of these instances has for example it's own toolbars.
Or if you open two different instances of word as I described in my earlier post and then go to the Windows Task Manager you see two different applications for Word running, but only one for Excel.
Yep you are right. The only way I was able to do it was to manually open excel 2 times and then load the two files. There should be an easier way.
My System SpecsSystem Spec
11 Jun 2010   #5
Bill2

Windows 7 x64 pro/ Windows 7 x86 Pro/ XP SP3 x86
 
 

My System SpecsSystem Spec
11 Jun 2010   #6
Luckystar

Windows 7 Ultimate x64 RTM + SP1
 
 

Sorry to hijack this thread.

Is there one for 2003 excel as this is what we use at my work and think this would be great for the company.

Lucky
My System SpecsSystem Spec
13 Jun 2010   #7
elsuirad

Windows® 7 Home Basic 64bit, Build 7600
 
 

This one's is pretty much better. I'm using MS Office 2003.

At first, when I open an Excel Spreadsheet file to edit something and then open another one to copy or compare 2 files but the problem is they can be seen only by switching pages.

I found this trick and followed it step-by-step and now, i can open excel files as much as I wanted and they can be seen all of them without and switching pages.

See it HERE.
My System SpecsSystem Spec
15 Jun 2010   #8
cyru11s

Windows 7
 
 

@Bill2
Thanks. That is what I was looking for.
My System SpecsSystem Spec
04 Sep 2010   #9
FrankTheMule

Vista Ultimate 32bit
 
 
Better solution

My System SpecsSystem Spec
07 Sep 2010   #10
pbcopter

Windows 7 Ultimate x64 SP1, Windows 8.1 Pro x64, Windows 10 Pro x64
 
 

I use, double click the first Excel file, then hold down the shift key and double click the next Excel file.
They will be in separate windows.
My System SpecsSystem Spec
Reply

 How do I open multiple Excel 2007 files in separate windows?




Thread Tools





Similar help and support threads
Thread Forum
Excel 2007 files are corrupted.
Hi all! Two days ago I have saved my workbooks on the mapped network drive, but now all files are corrupted.:cry: Excel tries to recover the corrupted data everytime I want to open it, but with no success. I removed all the links to external spreadsheets and read some topics with similar...
Microsoft Office
Excel 2010 Win7 Open Multiple Windows
I was searching for a way to open multiple windows in Excel every time I double clicked on an Xls or Xlsx file. I looked and found some solutions for 2007 and prior versions however I did not find any solutions for the Win7 Excel 2010 environment. (I did find a way to do it by changing a fix...
Microsoft Office
cannot open embedded pdf file in Excel 2007
Dear all, I cannot open embedded pdf file in Excel 2007 and Excel 2010. When I try to open it, I get a message: Cannot start the source application for this object. I checked the registery, the path is correct.:sick: HKEY_CLASSES_ROOT\CLSID\{B801CA65-A1FC-11D0-85AD-444553540000}\LocalServer32 ...
Microsoft Office
Excel files will not open from Outlook or Windows Exp
I have Win7 ultimate and Office 2010 beta. All of a sudden I can no longer double-click Excel attachments in Outlook or Windows Explorer and have them open. Excel launches but pulls up a blank Excel app. I can open all files from within Excel app just fine. I have tried repairing and...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 13:14.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App