Microsoft Knowledge Base Email Alertz

KBAlertz.com: When you double-click a Microsoft Excel workbook (.xls file) in Windows Explorer, Excel does not open the file. You may receive the following error message: Cannot find the file ' path' (or one of its components). Make sure the path and filename are...

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]





ASP.NET 2.0 Web Hosting with SQL 2005: Click Here!
Discount ASP.NET Hosting


Bug Tracking Software
For bug tracking software or defect tracking software or issue tracking software, visit Axosoft.


Community Site



We Send hundreds of thousands of emails using ASP.NET Email



Expert Web Design & Graphic Design
Design44.com




Mentioned In








Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks




Excel opens without displaying a workbook

Article ID:211494
Last Review:April 16, 2007
Revision:7.0
This article was previously published under Q211494

SYMPTOMS

When you double-click a Microsoft Excel workbook (.xls file or .xlsx file) in Microsoft Windows Explorer, Excel does not open the file, and you may receive the following error message:
Cannot find the file 'path' (or one of its components). Make sure the path and filename are correct and that all required libraries are available.

In Window Vista, when you double-click an Excel workbook, Excel does not open the file, and you may receive the following error message:
Windows cannot find 'FilePath\FileName', Make sure you typed the name correctly, and then try again.

Excel may actually open, but the file will not open. If Excel is already running, a second instance of Excel may start.

Back to the top

CAUSE

This problem may occur if the Ignore other applications setting in Excel is selected.

Back to the top

RESOLUTION

To resolve this problem, follow these steps:
1.In Microsoft Office Excel 2007, click the Microsoft Office Button, and then click Excel Options.
2.Click Advanced, and then click to clear the Ignore other applications check box in the General area.
3.Click OK.
1.In Microsoft Office Excel 2003 or earlier versions of Excel click Options, on the Tools menu.
2.Click the General tab.
3.Click to clear the Ignore other applications check box, and then click OK.
After you do this, you should be able to open workbooks by double-clicking them in Windows Explorer.

Back to the top

MORE INFORMATION

When you double-click an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel, instructing it to open the workbook that you double-clicked.

If the Ignore other applications setting is selected, Excel ignores DDE messages sent to it by other programs. As a result, the DDE message sent to Excel by Windows Explorer is ignored, and Excel does not open the workbook that you double-clicked.

Back to the top


APPLIES TO
•Microsoft Office Excel 2007
•Microsoft Excel 97 Standard Edition
•Microsoft Office Excel 2003
•Microsoft Excel 2002 Standard Edition
•Microsoft Excel 2000 Standard Edition

Back to the top

Keywords: 
kbconfig kbopenfile kbprb kbualink97 KB211494

Back to the top

       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Anonymous User Report As Irrelevant  
Written: 7/17/2006 3:00 PM
thanks, you helped me out. it was killing me opening everything up through excel

Anonymous User Report As Irrelevant  
Written: 8/3/2006 8:39 AM
Thanks...worked perfectly.

Bfoster Report As Irrelevant  
Written: 10/13/2006 9:05 AM
Thanks for the fix, I looked for about an hour before I found this fix. It worked great.

Anonymous User Report As Irrelevant  
Written: 10/31/2006 5:48 AM
Thanks for the fix. I already tried reinstalling office and anti virus before which dit not help.

Anonymous User Report As Irrelevant  
Written: 11/1/2006 12:58 PM
Cool, i usually only trust microsoft.com for support issues but did not see resolution to this problem, now i trust you too - thank you!

jamiro Report As Irrelevant  
Written: 11/6/2006 11:00 AM
Thanks,Thanks,Thanks,Thanks,Thanks,Thanks,Thanks,

Lhlalyam Report As Irrelevant  
Written: 1/31/2007 11:04 AM
Thanks for the tip... i did like a 1 minute search in regards to this problem and yours was the first to come up. When through the steps and it was fixed... many thank you's!

Marcus Report As Irrelevant  
Written: 2/2/2007 12:07 PM
Thank you! I had totally forgotten that I selected that option in an effort to keep Excel from reverting to the R1C1 reference style (hey, it's right under it, so why not)?

Anonymous User Report As Irrelevant  
Written: 2/7/2007 11:26 AM
Wasn't getting error message, but wasn't getting my workbooks through DDE either. Clicked option to turn it ON. DDE now works, and options tab for some reason shows that box as CLEARED!

Anonymous User Report As Irrelevant  
Written: 6/26/2007 7:46 PM
Thanks for your help. It worked. Not sure how we lived with Internet!!!

Anonymous User Report As Irrelevant  
Written: 8/13/2007 5:08 AM
go to: explorer->tools->folder options->file types->XLS->advanced->open->edit then uncheck "Use DDE"

Anonymous User Report As Irrelevant  
Written: 8/13/2007 5:10 AM
and make sure you have the quotes: "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e "%1"

Anonymous User Report As Irrelevant  
Written: 8/31/2007 7:32 AM
Need help! My settings are as you said they should be for excel 2007. but when i dbl-click an excel file it wont open the spread sheet. But if i minimize and maximize the window, or open the excel options and then cancel out of it, the spread sheet magically loads. How can i fix this so i dont have to keep maximizing and minimizing etc. to get a worksheet to open after i've double clicked it!?

Anonymous User Report As Irrelevant  
Written: 9/4/2007 2:16 PM
Thanks a lot...its really very helpfull

Anonymous User Report As Irrelevant  
Written: 9/25/2007 8:57 AM
Re the question on 8/31. I had the same problem of the worksheet not opening, or working, until the close or max or min buttons were clicked. It turned out that the quotes had disappeared from around the "%1" in command line as mentioned above. Added the quotes and all seems to be fine now.

Anonymous User Report As Irrelevant  
Written: 10/9/2007 1:38 PM
Perfect. Thank you!

Sarah Report As Irrelevant  
Written: 10/20/2007 5:09 PM
This was great, I tried Microsoft.com and couldn't get an answer, thanks for your help.

Anonymous User Report As Irrelevant  
Written: 11/5/2007 4:31 AM
Excellent work, keep it up

Anonymous User Report As Irrelevant  
Written: 11/29/2007 11:09 AM
Likewise, I have same problem with not opening a worksheet or workbook until I minimize Excel, then I find the desired worksheet/workbook beneath. I tried to follow the tip from 8-13 above but cannot find the folder option after tools step. go to: explorer->tools->folder options->file types->XLS->advanced->open->edit then uncheck "Use DDE" - Can anybody help?

Anonymous User Report As Irrelevant  
Written: 11/29/2007 11:28 AM
Ooops, False Alarm - I just figured out the information from 8-13 was talking about Windows Explorer - not Internet Explorer! Once I figured that out, the rest made sense and the edits suggested worked like a charm. I actually had to add the quotes and the %1, (enclosed in quotes, for it to work. That fixed the problem and it works like a champ now!! Many, many thanks to the contributors. Great Facility to share information and to help others!!!

Andy Report As Irrelevant  
Written: 12/10/2007 6:55 PM
The single most useful computer advice I have ever recieved...simple and effective. THANKS

OzTom Report As Irrelevant  
Written: 12/20/2007 11:57 AM
"%1" did the trick for me! Great help!

Dimitris Report As Irrelevant  
Written: 1/31/2008 2:31 AM
Yeah. That was. Thanks a lot

DP Report As Irrelevant  
Written: 2/6/2008 9:09 AM
Ditto on 90% of what everyone else found here. Worked as advertised.....Much Appreciated

Shehzad Report As Irrelevant  
Written: 3/17/2008 3:50 AM
Worked a wonder. Thank you

Jonathan Salzedo Report As Irrelevant  
Written: 3/25/2008 10:11 PM
Yes, it worked. I spent a lot of time trying to figure out this one. Thanks very much for posting the solution.

sam Report As Irrelevant  
Written: 4/7/2008 11:36 PM
thanx mate , it was so helpful , solved the problem less than a min which could have been ages, thanx a lot again

Jim Report As Irrelevant  
Written: 4/29/2008 5:42 AM
Thank you you saved me alot of hair

Tom Report As Irrelevant  
Written: 5/4/2008 6:34 PM
Thanks! Solve the problem;

Anonymous User Report As Irrelevant  
Written: 5/12/2008 12:02 PM
Thank you very much!! It worked perfectly!

syso Report As Irrelevant  
Written: 5/16/2008 7:06 AM
Thanks A Lot

Graham Report As Irrelevant  
Written: 5/21/2008 5:02 AM
One to remember. Hours saved from having to reinstall

Alex Report As Irrelevant  
Written: 6/25/2008 1:32 AM
thank you for your help. It works and save alot of my time.

Donna Report As Irrelevant  
Written: 9/10/2008 10:16 AM
Thanks so much. It was such a nuisance to have to minimize and maximize to load the files. The "%1" was missing in the Office12/excel.exe line.

Tochi Report As Irrelevant  
Written: 9/23/2008 7:39 AM
I have this problem before and it crops again in one of our user. This really saves me time. Thanks so much!

Scar Report As Irrelevant  
Written: 9/25/2008 6:39 AM
Solved, thx. Never heard of this feature anyway: I'm wondering how it turned on as I didn't mess up with excel settings lately.

unclerob Report As Irrelevant  
Written: 9/28/2008 5:42 PM
Spent hours on other sites trying to fix this. Wished I had found your link first. Worked like a charm. Thanks much.

Anonymous User Report As Irrelevant  
Written: 10/10/2008 2:37 AM
Thank you very much. Was killing me dragging everything...:)

(Optional) Name

(Optional) Public URL Or Email

Comments
No HTML -- Text Only Please