S
slickS
found the fix at this address
http://www.dailydoseofexcel.com/archives/2004/05/05/opening-excel-files-from-windows-explorer/
To fix this go into your File Explorer (My Computer) and Choose Folde
-> Options -> File Type. Find XLS and select it, then click advance
button. Now Select the “Open” Action and choose Edit button. Now thi
is the trick, shutoff DDE by unchecking it. Then edit the end of th
action. The end should be something like this (note the “%1″) an
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 everytim
you click on an Excel file. And when you close that excel instance i
has no impact on any other. It also gets rid of the I can’t find th
file problem. In some cases you will see a %1 without the quotes. Tha
causes the problem that excel can’t find files when the path has space
in it
http://www.dailydoseofexcel.com/archives/2004/05/05/opening-excel-files-from-windows-explorer/
To fix this go into your File Explorer (My Computer) and Choose Folde
-> Options -> File Type. Find XLS and select it, then click advance
button. Now Select the “Open” Action and choose Edit button. Now thi
is the trick, shutoff DDE by unchecking it. Then edit the end of th
action. The end should be something like this (note the “%1″) an
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 everytim
you click on an Excel file. And when you close that excel instance i
has no impact on any other. It also gets rid of the I can’t find th
file problem. In some cases you will see a %1 without the quotes. Tha
causes the problem that excel can’t find files when the path has space
in it