open different workbooks in individual instances of excel

E

ed godlewski

I am unable to open multiple workbooks in multiple instances of excel - like
opening multiple word documents in multiple instances of word - is there some
setting or workaround that can resolve this? Working on multiple workbooks in
the same window/instance is very slow, confusing and should be un-necessary
 
D

Dave Peterson

If you open the file via doubleclicking in windows explorer:

You can change this setting (xl2003 menus):
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 I want separate
instances, I'll just start a second instance and use File|Open.

I like a single instance so that I can easily copy between workbooks.
 

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

Top