Clicking on shortcut to .xls file opens it twice

W

Wowbagger

I have a shortcut to an .xls file set that suggests that it be opened as
read only.

When I click the link the system actualy opens the file twice - it prompts
me to open read only, opens, then prompts me again.

The open method as defined in Folder Options is as follows:

Application used to perform action:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Use DDE

DDE Message:
[open("%1")]

Why is this behaving this way?
 
K

KimC

I am having exactly the same problem (Office 2007). Did anyone ever answer
this post---maybe in another thread?
 
R

Ross

Hi there,

I might be wrong, but it seems that you're opening the file by passing the
file ref and by using DDE as well.

Have you tried changing:

C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

to

C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e /dde

Or unticking the DDE box and leaving the command as is?

Cheers,

Ross.
 
B

Beth Melton

You can recreate the file associations, which is causing the issue, but
going to Start/Run and running the following command:

excel /regserver

Note the space before the forward slash.

Additionally, this method has been found to work more successfully than
modifying the command manually. Even though it appears to be correct,
occasionally the Registry contains information that isn't visible when you
edit the File Type or Windows appends additional information, such as %1
(which represents the file name - in this case it's not represented
correctly and it breaks spaces in the path and file name) at the end of the
command line even though you deleted it, and the only way to remove it is by
editing the Registry or using the /regserver switch. For some reason Excel
is especially a bit more difficult.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

KimC said:
I am having exactly the same problem (Office 2007). Did anyone ever answer
this post---maybe in another thread?

Wowbagger said:
I have a shortcut to an .xls file set that suggests that it be opened as
read only.

When I click the link the system actualy opens the file twice - it
prompts
me to open read only, opens, then prompts me again.

The open method as defined in Folder Options is as follows:

Application used to perform action:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Use DDE

DDE Message:
[open("%1")]

Why is this behaving this way?
 
Top