Double click to open Excel/Word files

[wshanks]

Office 3003 allowed you to open Excel or Word files via "Double Clicking" on
the filename. Office 2007 does not always open the file promptly. On certain
PCs double clicking works as you would think it should.

On other PCs, configured the same, when you double click it opens the
application (Excel/Word) and then sits there doing nothing. If you click on
the Office button in the upper left corner it opens or... if you let it sit
for about 60 seconds, small file, it will open.

Have tried unregistering and re-registering, turning off virus checking,
shift-right click, open with and checking always open with this type, and
changing the setting in Excel to disable DDE checking.

Any thoughts? Thanks

 

[Bob I]

Try enabling an Add-in, in Excel I used Solver.

 

[ohnonotnow!]

Try enabling an Add-in, in Excel I used Solver.

mmmm..bob, what does that do? and how? i've a similar if not the same
scenario. thanks.

//onnn!

 

[Bob I]

:




mmmm..bob, what does that do? and how? i've a similar if not the same
scenario. thanks.

What does what do?

Enabling an Add-in? It corrects the major pause that some users
experience in Excel after double clicking a file.


and how what?

How to enable an Add-in? Solver is an Excel Add-in. If you look up
Add-in in Help, it is the first link returned. (Copy/pasted below)

Click the Microsoft Office Button , click Excel Options, and then click
Add-Ins.
In the Add-ins box, identify the add-in that you want to enable or
disable and note the Add-in type located in the Type column.
Select the Add-in type in the Manage box and then click Go.
Select or clear the check box for the Add-in that you want enable or
disable and then click OK.

 

[wshanks]

Tried addins - did not work. This problem seems to exist for both word and
excel in office 2007, but not on every PC.

 

[ohnonotnow!]

What does what do?

Enabling an Add-in? It corrects the major pause that some users
experience in Excel after double clicking a file.


and how what?

How to enable an Add-in? Solver is an Excel Add-in. If you look up
Add-in in Help, it is the first link returned. (Copy/pasted below)

.....

thanks for the reply, bob. i am asking, what does enabling an add-in, *any*
add-in apparently, how does this solve the OP's problem.

AND how does Solver, an analysis tool, how does it fix a problem that
involves opening the excel program.

i'm willing to accept that it can, but i'd like to know the rationale and
how, if possible. searches at office online at excel 2007 hasn't given me
the answer, so i figured since you proposed it, you'd be able to help.

thanks
//onnn!

 

[ohnonotnow!]

Office 3003 allowed you to open Excel or Word files via "Double Clicking" on
the filename. Office 2007 does not always open the file promptly. On certain
PCs double clicking works as you would think it should.......

wshanks -- are you using a trial version by any chance?

i am, and this and a couple of other little oddities, i an hoping will be
solved when i get my own office 2007 suite upgrade.

//onnn!

 

[Beth Melton]

AND how does Solver, an analysis tool, how does it fix a problem that
involves opening the excel program.

I'm curious to hear more about this too. I suspect it has something to do
with the DDE issue you found previously but I'm trying to figure out how
they are related.

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx

 

[Bob I]

:



thanks for the reply, bob. i am asking, what does enabling an add-in, *any*
add-in apparently, how does this solve the OP's problem.

AND how does Solver, an analysis tool, how does it fix a problem that
involves opening the excel program.

i'm willing to accept that it can, but i'd like to know the rationale and
how, if possible. searches at office online at excel 2007 hasn't given me
the answer, so i figured since you proposed it, you'd be able to help.

thanks
//onnn!

It apparently didn't solve the OPs problem. It does work on Excel on
half a dozen machines I've tried it on, and for numerous folks that have
tried it in newsgroups here. Rational was that after an Add-in was
enabled the long pause quit happening, so when someone else complained,
we tried it as a "cure" and it worked. Conjecture is that something gets
set by enabling the Add-in and Excel doesn't time out anymore. Also, the
"pause" doesn't seem to return if you un-enable the add-in, so it isn't
the add-in itself that is doing it.

 

[Bob I]

The slow opening of Excel and enabling the Solver worked for me. I
suppose it is possible you have a DDE contention going and the solution
that worked for Office 2000 through 2003 may work. That involved
removing the DDE reference for the Excel and Word files in the File Type
manager in Folder Options. I have not tried that with 2007. But here
it is if you wish to try it. (Copied from an earlier posting about 2003)


Go to Control Panel, Folder Options, File Types, scroll down to and
select (DOC for Word files) or XLS (for Excel files), click Advanced,
select Open entry, click the edit Button.
Now uncheck "Use DDE" and then put your cursor in the Application box,
arrow all the way to the right and put in a space and then "%1" (include
the quote marks), IF there is /dde remove it. Then OK your way out.

 

[Bob I]

I'm curious to hear more about this too. I suspect it has something to
do with the DDE issue you found previously but I'm trying to figure out
how they are related.

Don't know whether it's DDE related or not. It doesn't seem to matter
which Add-in you pick, and after the "issue" is corrected, un-enabling
the add-in doesn't seem to break it. So far I have personally only seen
it in Excel, not Word. The "DDE" I saw in "Word and Excel".

 

[Beth Melton]

Don't know whether it's DDE related or not. It doesn't seem to matter
which Add-in you pick, and after the "issue" is corrected, un-enabling
the add-in doesn't seem to break it. So far I have personally only seen
it in Excel, not Word. The "DDE" I saw in "Word and Excel".

Interesting!
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx