File associate setting in Excel

[Guest]

I found a very strange instance.

When I double click a excel file, for example form the path
"D:\Profiles\jimmyl\My Documents\05. ABC.xls"

Excel with Open the file "D:\Profiles\jimmyl\My" first and result in file
not found, and then open "Documents\05." and result in file not found, and
then
open the file "ABC.xls" and result in file not found. At last it will open
the file. How come windows treat the space as a space and separate the
opening of a single file?

I found that it may be related to the Windows Explorer file associate
setting. The following setting is found.
Action - &Open
Application used to perform action - "C:\Program Files\Microsoft
Office\OFFICE11\EXCEL.EXE" /e %1
Use DDE
DDE Message - [open("%1")]
Application - EXCEL
Topic - System

Any ideas to fix this problem? And I try to delete the "%1" after /e but it
fail, why? Any can help?

Regards,
Jim28

 

[Nick Hodge]

Jim

In Excel try Tools>Options>General>Ignore other applications (un-checked)

If this fails, go to start>run... in Windows and enter excel.exe \regserver
(You may need to enter the full path of Excel exe)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

I have try both option, but didn't work. Thanks.

Jim

In Excel try Tools>Options>General>Ignore other applications (un-checked)

If this fails, go to start>run... in Windows and enter excel.exe \regserver
(You may need to enter the full path of Excel exe)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

I found a very strange instance.

When I double click a excel file, for example form the path
"D:\Profiles\jimmyl\My Documents\05. ABC.xls"

Excel with Open the file "D:\Profiles\jimmyl\My" first and result in file
not found, and then open "Documents\05." and result in file not found, and
then
open the file "ABC.xls" and result in file not found. At last it will open
the file. How come windows treat the space as a space and separate the
opening of a single file?

I found that it may be related to the Windows Explorer file associate
setting. The following setting is found.
Action - &Open
Application used to perform action - "C:\Program Files\Microsoft
Office\OFFICE11\EXCEL.EXE" /e %1
Use DDE
DDE Message - [open("%1")]
Application - EXCEL
Topic - System

Any ideas to fix this problem? And I try to delete the "%1" after /e but
it
fail, why? Any can help?

Regards,
Jim28

 

[Guest]

Thanks Dave. It's works.

Some people have posted that when they unregister excel, it gets fixed.

This is my standard answer:

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

I have try both option, but didn't work. Thanks.

Jim

In Excel try Tools>Options>General>Ignore other applications (un-checked)

If this fails, go to start>run... in Windows and enter excel.exe \regserver
(You may need to enter the full path of Excel exe)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)


I found a very strange instance.

When I double click a excel file, for example form the path
"D:\Profiles\jimmyl\My Documents\05. ABC.xls"

Excel with Open the file "D:\Profiles\jimmyl\My" first and result in file
not found, and then open "Documents\05." and result in file not found, and
then
open the file "ABC.xls" and result in file not found. At last it will open
the file. How come windows treat the space as a space and separate the
opening of a single file?

I found that it may be related to the Windows Explorer file associate
setting. The following setting is found.
Action - &Open
Application used to perform action - "C:\Program Files\Microsoft
Office\OFFICE11\EXCEL.EXE" /e %1
Use DDE
DDE Message - [open("%1")]
Application - EXCEL
Topic - System

Any ideas to fix this problem? And I try to delete the "%1" after /e but
it
fail, why? Any can help?

Regards,
Jim28