I'm using Excel 2007, and would like to be able to open files in separate
windows. I've read some of the other responses, but haven't figured it out.
I have the "show all windows in taskbar" option checked, and all of them do
show up in the taskbar. But if I have a file open, and open a second (or
third) file, it automatically opens in the same window as the other file.
I'm familiar with splitting panes, etc., but I'm wondering (hoping!) that
there's a way that I can have separate files open in separate windows that I
can click on and move around my monitor separately from each other. Is that
possible?
Thanks.

ViewNew Window.

ViewArrange All


Gord Dibben MS Excel MVP

On Tue, 14 Jul 2009 07:26:01 -0700, THR
wrote:

I'm using Excel 2007, and would like to be able to open files in separate
windows. I've read some of the other responses, but haven't figured it out.
I have the "show all windows in taskbar" option checked, and all of them do
show up in the taskbar. But if I have a file open, and open a second (or
third) file, it automatically opens in the same window as the other file.
I'm familiar with splitting panes, etc., but I'm wondering (hoping!) that
there's a way that I can have separate files open in separate windows that I
can click on and move around my monitor separately from each other. Is that
possible?
Thanks.

If you're using multiple monitors, you may want to review Chip Pearson's notes:
http://cpearson.com/excel/MultipleMonitors.aspx

THR wrote:

I'm using Excel 2007, and would like to be able to open files in separate
windows. I've read some of the other responses, but haven't figured it out.
I have the "show all windows in taskbar" option checked, and all of them do
show up in the taskbar. But if I have a file open, and open a second (or
third) file, it automatically opens in the same window as the other file.
I'm familiar with splitting panes, etc., but I'm wondering (hoping!) that
there's a way that I can have separate files open in separate windows that I
can click on and move around my monitor separately from each other. Is that
possible?
Thanks.

--

Dave Peterson

Those commands split the files inside of one window, but they do not allow
the files to be opened in completely different windows.

"Gord Dibben" wrote:

ViewNew Window.

ViewArrange All


Gord Dibben MS Excel MVP

On Tue, 14 Jul 2009 07:26:01 -0700, THR
wrote:

I'm using Excel 2007, and would like to be able to open files in separate
windows. I've read some of the other responses, but haven't figured it out.
I have the "show all windows in taskbar" option checked, and all of them do
show up in the taskbar. But if I have a file open, and open a second (or
third) file, it automatically opens in the same window as the other file.
I'm familiar with splitting panes, etc., but I'm wondering (hoping!) that
there's a way that I can have separate files open in separate windows that I
can click on and move around my monitor separately from each other. Is that
possible?
Thanks.

You likely don't really want to do that anyway because of the way things
stop working when you open two instances of Excel.

THR wrote:
Those commands split the files inside of one window, but they do not allow
the files to be opened in completely different windows.

"Gord Dibben" wrote:


ViewNew Window.

ViewArrange All


Gord Dibben MS Excel MVP

On Tue, 14 Jul 2009 07:26:01 -0700, THR
wrote:


I'm using Excel 2007, and would like to be able to open files in separate
windows. I've read some of the other responses, but haven't figured it out.
I have the "show all windows in taskbar" option checked, and all of them do
show up in the taskbar. But if I have a file open, and open a second (or
third) file, it automatically opens in the same window as the other file.
I'm familiar with splitting panes, etc., but I'm wondering (hoping!) that
there's a way that I can have separate files open in separate windows that I
can click on and move around my monitor separately from each other. Is that
possible?
Thanks.

I concur with Bob's statement.


Gord

On Fri, 24 Jul 2009 11:53:41 -0500, Bob I wrote:

You likely don't really want to do that anyway because of the way things
stop working when you open two instances of Excel.

THR wrote:
Those commands split the files inside of one window, but they do not allow
the files to be opened in completely different windows.

"Gord Dibben" wrote:


ViewNew Window.

ViewArrange All


Gord Dibben MS Excel MVP

On Tue, 14 Jul 2009 07:26:01 -0700, THR
wrote:


I'm using Excel 2007, and would like to be able to open files in separate
windows. I've read some of the other responses, but haven't figured it out.
I have the "show all windows in taskbar" option checked, and all of them do
show up in the taskbar. But if I have a file open, and open a second (or
third) file, it automatically opens in the same window as the other file.
I'm familiar with splitting panes, etc., but I'm wondering (hoping!) that
there's a way that I can have separate files open in separate windows that I
can click on and move around my monitor separately from each other. Is that
possible?
Thanks.

I'm not sure what you mean by that. With older versions of Excel, you could
open as many different windows as you wanted without problems. Are you
telling me that isn't possible - or at least workable - with 2007?

"Bob I" wrote:

You likely don't really want to do that anyway because of the way things
stop working when you open two instances of Excel.

THR wrote:
Those commands split the files inside of one window, but they do not allow
the files to be opened in completely different windows.

"Gord Dibben" wrote:


ViewNew Window.

ViewArrange All


Gord Dibben MS Excel MVP

On Tue, 14 Jul 2009 07:26:01 -0700, THR
wrote:


I'm using Excel 2007, and would like to be able to open files in separate
windows. I've read some of the other responses, but haven't figured it out.
I have the "show all windows in taskbar" option checked, and all of them do
show up in the taskbar. But if I have a file open, and open a second (or
third) file, it automatically opens in the same window as the other file.
I'm familiar with splitting panes, etc., but I'm wondering (hoping!) that
there's a way that I can have separate files open in separate windows that I
can click on and move around my monitor separately from each other. Is that
possible?
Thanks.