workbook confusion

[Everett Joline]

When I attempt to close a particular Excel file I sometimes
get asked if I want to save the changes of some completely different
file. It seems to me that Excel is merging two separate workbooks.

If this observed behavior is correct, how can I change the
behavior so that separate files are not merged?

(Or is it me who is confused?)
Thanks,
E-Jo

[Everett Joline]

To clarify my confusion a little:
My status bar shows that I have two xls files open.
But there is only one shown open on the screen at any time.
(I can switch between them by clicking on the status bar icon.)
However, I would like to have them both shown on the screen,
completely independent of each other.
How do I do that??
Thanks,
E-Jo

"Everett Joline" <ejoline@optonline.net> wrote in message
news:uKOWPsuYFHA.3488@tk2msftngp13.phx.gbl...
> When I attempt to close a particular Excel file I sometimes
> get asked if I want to save the changes of some completely different
> file. It seems to me that Excel is merging two separate workbooks.
>
> If this observed behavior is correct, how can I change the
> behavior so that separate files are not merged?
>
> (Or is it me who is confused?)
> Thanks,
> E-Jo
>

[Dave Peterson]

You can have them appear within separate windows inside the single instance of
excel by:

Window|Arrange|horizontal (or your choice).

To have them completely independent of each other, you would have to open a
second instance of excel and then open the second workbook in that second
instance.

One way to start a second instance is to create a shortcut on your desktop that
starts excel.

Or just windows start button|Run
type: Excel
and click ok.

Everett Joline wrote:
>
> To clarify my confusion a little:
> My status bar shows that I have two xls files open.
> But there is only one shown open on the screen at any time.
> (I can switch between them by clicking on the status bar icon.)
> However, I would like to have them both shown on the screen,
> completely independent of each other.
> How do I do that??
> Thanks,
> E-Jo
>
> "Everett Joline" <ejoline@optonline.net> wrote in message
> news:uKOWPsuYFHA.3488@tk2msftngp13.phx.gbl...
> > When I attempt to close a particular Excel file I sometimes
> > get asked if I want to save the changes of some completely different
> > file. It seems to me that Excel is merging two separate workbooks.
> >
> > If this observed behavior is correct, how can I change the
> > behavior so that separate files are not merged?
> >
> > (Or is it me who is confused?)
> > Thanks,
> > E-Jo
> >

--

Dave Peterson

[Everett Joline]

Thanks, that's great Dave, also I guess I can do it by clicking Window|new
window.
However, is there any way I can make this the default so that I don't need
to
keep going through all this?

Thanks,
E-Jo

"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:42979F54.40D8D091@netscapeXSPAM.com...
> You can have them appear within separate windows inside the single
> instance of
> excel by:
>
> Window|Arrange|horizontal (or your choice).
>
> To have them completely independent of each other, you would have to open
> a
> second instance of excel and then open the second workbook in that second
> instance.
>
> One way to start a second instance is to create a shortcut on your desktop
> that
> starts excel.
>
> Or just windows start button|Run
> type: Excel
> and click ok.
>
> Everett Joline wrote:
>>
>> To clarify my confusion a little:
>> My status bar shows that I have two xls files open.
>> But there is only one shown open on the screen at any time.
>> (I can switch between them by clicking on the status bar icon.)
>> However, I would like to have them both shown on the screen,
>> completely independent of each other.
>> How do I do that??
>> Thanks,
>> E-Jo
>>
>> "Everett Joline" <ejoline@optonline.net> wrote in message
>> news:uKOWPsuYFHA.3488@tk2msftngp13.phx.gbl...
>> > When I attempt to close a particular Excel file I sometimes
>> > get asked if I want to save the changes of some completely different
>> > file. It seems to me that Excel is merging two separate workbooks.
>> >
>> > If this observed behavior is correct, how can I change the
>> > behavior so that separate files are not merged?
>> >
>> > (Or is it me who is confused?)
>> > Thanks,
>> > E-Jo
>> >
>
> --
>
> Dave Peterson

[Dave Peterson]

Window|New window actually opens another window of the same workbook.

Window|arrange will give you options to display all the windows that are open.

If you save a workbook with multiple windows, you'll see one of those windows
(book1.xls:1 or book1.xls:2 in the title bar).

If you keep all your excel worksheet windows less than maximized, then excel
will remember that when you open the workbooks.

You still may have to arrange windows to get them to display the way you want,
though.



Everett Joline wrote:
>
> Thanks, that's great Dave, also I guess I can do it by clicking Window|new
> window.
> However, is there any way I can make this the default so that I don't need
> to
> keep going through all this?
>
> Thanks,
> E-Jo
>
> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> news:42979F54.40D8D091@netscapeXSPAM.com...
> > You can have them appear within separate windows inside the single
> > instance of
> > excel by:
> >
> > Window|Arrange|horizontal (or your choice).
> >
> > To have them completely independent of each other, you would have to open
> > a
> > second instance of excel and then open the second workbook in that second
> > instance.
> >
> > One way to start a second instance is to create a shortcut on your desktop
> > that
> > starts excel.
> >
> > Or just windows start button|Run
> > type: Excel
> > and click ok.
> >
> > Everett Joline wrote:
> >>
> >> To clarify my confusion a little:
> >> My status bar shows that I have two xls files open.
> >> But there is only one shown open on the screen at any time.
> >> (I can switch between them by clicking on the status bar icon.)
> >> However, I would like to have them both shown on the screen,
> >> completely independent of each other.
> >> How do I do that??
> >> Thanks,
> >> E-Jo
> >>
> >> "Everett Joline" <ejoline@optonline.net> wrote in message
> >> news:uKOWPsuYFHA.3488@tk2msftngp13.phx.gbl...
> >> > When I attempt to close a particular Excel file I sometimes
> >> > get asked if I want to save the changes of some completely different
> >> > file. It seems to me that Excel is merging two separate workbooks.
> >> >
> >> > If this observed behavior is correct, how can I change the
> >> > behavior so that separate files are not merged?
> >> >
> >> > (Or is it me who is confused?)
> >> > Thanks,
> >> > E-Jo
> >> >
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson