workbook confusion

  • Thread starter Thread starter Everett Joline
  • Start date Start date
E

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
 
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
 
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.
 
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
 
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.
 
Back
Top