open a new excel window for each excel doc

  • Thread starter Thread starter cwspalmer
  • Start date Start date
C

cwspalmer

In Excel 2003, when I open more than one excel doc, it opens within the same
window. Where do I change the settings to open a new excel window for every
excel doc I open?
 
If you want separate windows within the same instance of excel, you can try:
Tools|Options|View tab|Show section|Check Windows in Taskbar

If you really want separate instances of excel...

If you use File|Open within excel, then each of these workbooks will be open in
the same instance of excel. This won't work for you.

If you open the file via doubleclicking in windows explorer:

You can change this setting:
Tools|Options|General tab|Ignore other applications (check it)

Be aware that one side effect of having this setting checked is sometimes you
can't open a file by double clicking on it in explorer. (toggle it back and
that should be fixed.)

This shows up for workbooks that have spaces in their name or path:
c:\my documents\excel\testworkbook.xls
or
c:\test of workbook2.xls

Cannot find C:\my, then more "Cannot find ..." messages.

It's more trouble than it's worth (for me, anyway).

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - 2nd Request 3
Open an excel file 1
Securing an Excle File? 1
Excell 2021 0
Excel 2010 1
Excel docs not saving as excel docs 6
Open Excel in 2002 not 2007 1
opening excel docs in a new window 5

Back
Top