Solved

Office Word / Excel 2007 will not open a file if double-clicked

Posted on 2011-09-16
6
280 Views
Last Modified: 2012-05-12
When trying to open Word/Excel files, we get the below message on a client PC:

Windows cannot find 'FilePath\FileName', Make sure you typed the name correctly, and then try again.

Open in new window


I discovered the option within Excel to "ignore other applications that use DDE" and confirmed this fix does NOT work.

According to my understanding, when double-clicking a file, it should send a DDE request to the program which will then open the file.  I'm fairly convinced the error lies in this function, HOWEVER, I have discovered the following:

When I log on, I don't have the same problem
When the program is already running, the file will open

I don't know, but would imagine DDE-related things were not profile-specific, so I'm inclined to say that the above evidence means the problem is not related to those settings, especially because it seems DDE-related settings are stored in HKEY_CLASSES_ROOT.

One other thing I noticed was that Office updates were deployed to the affected client machine on the same day of the occurence, but the user complained the problem was happening before this, just got worse today (at first she couldn't open files which were attachments; today it became any files opened from the shell.

I've tried re-associate the file extension with the program: no effect.  I'm planning to repair Office and/or reinstall, but given that the problem is not present for other logins, I don't hold out much hope.  Also the problem is occuring in a remote office, so copying the files will take all of tonight.  If I can't find out any further clues, I will probably try recreating the profile, but it's a drastic action I'd like to avoid and there's no actual gaurantee this will resolve the problem.

Really, it seems to me there is something DDE-specific which related to your profile, but I haven't a clue what it could be.  Poking around in the registry, I haven't been able to chance upon anything promising.  If anyone has any ideas it would be very much apreciated.  I've also searched the Microsoft Knowledge base, without turning up anything useful.
0
Comment
Question by:NeoI5theOne
  • 2
  • 2
6 Comments
 
LVL 50

Expert Comment

by:jcimarron
ID: 36554539
0
 
LVL 16

Accepted Solution

by:
cantoris earned 500 total points
ID: 36554931
Log in as the affected user.  Open regedit and go to :

HKCU/Software/Classes

Are there subkeys in there (ie rather than just under HKLM)  for Office filetypes such as  .doc, .docx, .xls, .xlsx  etc?  If so, why not try exporting those keys (as a backup), deleting them and logging off and back on.  You don't sound like someone who needs to be warned about playing in the registry :)

If you did find entries there, and deleting them didn't work, log in as a working account and see if it has such keys too - if so, export them and then re-import them into the dodgy profile.
0
 

Author Comment

by:NeoI5theOne
ID: 36891692
Hi Cantoris, thanks for your suggestion; as it happens I did try to repair Office the week after posting and it fixed the problem, surprisingly.  I'll try your suggestion next time as well (I get the feeling this is going to crop up again from time to time in our wonderful environment).
0
 

Author Closing Comment

by:NeoI5theOne
ID: 36891699
Tried an alternative which solved the problem, but would like to try the suggested fix the next time the problem happens.
0
 
LVL 16

Expert Comment

by:cantoris
ID: 36891755
Thanks for giving me points anyway  :)
Good luck next time.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now