I don't believe that Word works this way (normally).

It may look like several instances of Word, but it's not. (The interface works
differently than excel, though. Word's Single Document Interface is different
than excel's windows in taskbar.)

I agree with Bob, too. I try to only open one instance of excel and have
multiple workbooks open within that instance.

But maybe you could force a separate instance of excel by:

Tools|options|general|check Ignore other applications

This may result in "cannot find" error messages when the folder/filename
contains spaces.

(so it might not be much of a fix!)

If I really want multiple instances, I'll start a second instance manually.

Usually clicking on a shortcut to excel.exe will do it.

Then File|open.

====
But I find multiple instances more difficult to work with. Try copying a range
with formulas from one instance to another instance (and you'll see one of my
objections).



John B wrote:

This is maybe another variation of the excel instance issue. I have an
Access app that uses bound object frames to manage document data. Each open
document of whatever type gets its own bound object frame bound to an OLE
Object table record. With Word and other apps, opening multiple documents
results in multiple instances of the app. This is the that the users want
things to work. With Excel, only one instance of Excel is opened no matter
how many documents are opened. Each doc has its own bound object frame bound
to its own table record but there is only one instance of excel. The users
find this very unnatural and would like to see the same behavior as Word,
each doc in its own instance. I have tried all combinations of Windows in
Taskbar and Ignore other apps and the behavior is always the same, only one
instance of Excel.

Does anyone have any ideas on how to force separate instances of Excel, one
per worksheet?

--

Dave Peterson