Opening excel file in new window

R

Ravi

When an excel is already open in a window and I open a new excel file it
opens in the same window. How do I make it open in a new window?
 
H

Harald Staff

You can't. Excel has two windows only; Excel and the VB editor.

You may be able to open another instance of Excel though, with some Windows
trick or by code. But that is spending a lot of power just for an extra
window.

HTH. best wishes Harald
 
P

paul

i dont understand am i missing something?...the current workbook is always on
top,but other workbooks can be open in seperate windows,you can toggle
between them from the taskbar,or alt tab between them,or se the excel windows
menu and the window menu also has a choice of new window so you can have
different parts of the same workbook open in seperate windows.In xp there is
even a choice to compare two open workbooks side by side--

Paul
 
R

Ravi

In my earlier PC i used get the excel opened in new windows and i could do
alt tab to switch between windows. but in my new laptop all excel file opens
in the same window. I use XP. and when I click on new window, the excel file
opens again in the same window. There should be a way, i am sure. hope i get
an answer. Thanks for the response.
 
J

Jim May

Under Tools, Options, View Tab look for "Show" - Windows in Task Bar and
Check..
Is this what you want?
 
H

Harald Staff

Alt-Tab, and taskbar representations, is done as Jim explains, Tools >
Options, select Windows in taskbar. It is still one window though; minimize
Excel and they all go down there.

BTW it's Ctrl F6 to switch between windows inside Excel. You get used to
that pretty fast.

HTH. Best wishes Harald
 
R

Randy

Hello, I had the same problem, I posted here and elsewhere but no one could
help, I finally found the solution by mistake. Here it is

Open window explorer by right clicking the Start button and select Explore.
Windows Explorer opens, now select "Tools" then on the dropdown menu select
"Folder Options". In Folder Options , select the "File Types" tab.
Now scroll down until you see the file type of "XLS" under the column labled
"Extensions" Click on "XLS" to select it.
Next click on the Advanced button and then under "Actions" Click on "Open"
The Confirm open after download should be checked and the other two....
1. Always show extension
2. Browse same window

Should not be checked.

Next click "Edit"

Under Application used to perform action delete what is there (All of it)
and copy and paste the following into this space.

"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" "%1"

Make sure the box "DDE Message" is clear and the Check Box labled "Use DDE"
is checked.
You are done, click OK, Ok and Close. Now when you click on XLS files each
will open in it own window. (Hopefully)
 
Top