to open multiple instances of excel
 

found the fix at this address
http://www.dailydoseofexcel.com/arch...dows-explorer/

To fix this go into your File Explorer (My Computer) and Choose Folder
- Options - File Type. Find XLS and select it, then click advanced
button. Now Select the “Open” Action and choose Edit button. Now this
is the trick, shutoff DDE by unchecking it. Then edit the end of the
action. The end should be something like this (note the “%1″) and
note there must be a space between the /e and the first quote.

“C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE” /e “%1″

Now this allows you to create a SEPERATE instance of excel everytime
you click on an Excel file. And when you close that excel instance it
has no impact on any other. It also gets rid of the I can’t find the
file problem. In some cases you will see a %1 without the quotes. That
causes the problem that excel can’t find files when the path has spaces
in it.


--
slickS
------------------------------------------------------------------------
slickS's Profile: http://www.excelforum.com/member.php...o&userid=37727
View this thread: http://www.excelforum.com/showthread...hreadid=573972