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 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
KBAlertz referrals get
** SIX MONTHS FREE **


Community Site



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


ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
KBAlertz referrals get
** SIX MONTHS FREE **




Mentioned In








Microsoft Knowledge Base Article

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




Article ID: 211494 - Last Review: April 16, 2007 - Revision: 7.0

Excel opens without displaying a workbook

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.

CAUSE

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

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.

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.

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
Keywords: 
kbconfig kbopenfile kbprb kbualink97 KB211494
       

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!

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!

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...:)

TC Report As Irrelevant  
Written: 10/16/2008 6:11 AM
Great, thank you. Did a system restore and it started after, this solved it.

Steve Report As Irrelevant  
Written: 11/10/2008 12:07 PM
Top man - worked a treat !!

Vinod Taori - vinodtaori NOSPAM-AT-NOSPAM yahoo.com Report As Irrelevant  
Written: 11/12/2008 2:34 AM
Dear , Thanks For the Valuable Tips. It Works fine. Thnaks Again.

Tranman Report As Irrelevant  
Written: 11/25/2008 2:02 PM
Article should have mentioned the "%1" solution, as well as the "Ignore..." solution. I wonder how many people read the MS article, try the first solution, and give up, without reading the "Community Feedback", wherein lies the solution for many of us.

Anonymous User Report As Irrelevant  
Written: 12/17/2008 5:13 AM
We tried all the advice and problem still occurs with files that have a space in the name or a space in one of the directory path names.

Its Me Report As Irrelevant  
Written: 1/17/2009 1:52 PM
I have similar issue, my .xls file doesn't open when double clicked. I have done all the points mentioned above no success. The reason behind the file not getting opened is one of my VBA Addin. This addin actually creates a toolbar and Menu. If I remove the addin then everything works fine. I need to display the addin. could some one tell me how to resolve this issue

Anonymous User Report As Irrelevant  
Written: 1/20/2009 4:07 AM
This solved the problem! Thank you! Now I'm just curious as to how the problem started in the first place, because it worked fine for over a year before it started misbehaving. I'm sure I didn't check the "Ignore other Applications box, so I wonder how that setting got changed?

Anonymous User Report As Irrelevant  
Written: 1/31/2009 4:39 AM
thanks! worked for me. it was getting irritating to open excel files the other way :)

aldjf Report As Irrelevant  
Written: 3/25/2009 2:12 AM
Nope, no worky for me :(

GOOD TO GOOD - G2G Report As Irrelevant  
Written: 3/26/2009 12:12 PM
PERFECT EASY SOLUTION FOR NO COMMON PROBLEM

rr Report As Irrelevant  
Written: 3/29/2009 6:51 AM
i reinstalled office, did not solve the problem,yes this advice worked well and has resolved the issue , thanx a lot.

Anonymous User Report As Irrelevant  
Written: 4/1/2009 10:36 PM
Thanks for your tip. It worked! and saved me a lot of time and annoying thing which I had to go throgh earlier

Anonymous User Report As Irrelevant  
Written: 4/3/2009 7:05 AM
another satisfied user. much appreciated.

Jose Fernando Report As Irrelevant  
Written: 4/23/2009 3:03 PM
Thanks I worked perfectly :D

INDRAJIT ROY Report As Irrelevant  
Written: 7/6/2009 10:33 AM
THANKS,AS PER THE GUIDELINE PROVIDED MY PROBLEM IS SOLVED.

IGN Report As Irrelevant  
Written: 7/7/2009 3:41 PM
Thanks a lot from Catalonia. It works and finally I will be able to go bed. THANKS. You are GREAT, Huge, ...

Anonymous User Report As Irrelevant  
Written: 7/21/2009 9:02 AM
Worked like a charm! Thanks.

Anonymous User Report As Irrelevant  
Written: 7/28/2009 9:45 AM
Another satisfied customer! THANKS!

vinod Report As Irrelevant  
Written: 7/30/2009 7:17 AM
Verry verry thanks ful to you for the resolution

swissfern Report As Irrelevant  
Written: 8/13/2009 12:21 AM
Thanks! You save minutes of my life with this fix!!!!

Anonymous User Report As Irrelevant  
Written: 8/21/2009 10:14 AM
"%1" worked for me too!

Pablo ARGENTINA Report As Irrelevant  
Written: 9/1/2009 12:53 PM
Works great. I was dealing with this issue for the last months...THANKS!!!

Anonymous User Report As Irrelevant  
Written: 9/2/2009 11:37 PM
It is so Great! I was annoyed with this problem! It was working good, then I got inot this trouble. Now with these steps, it is back into action. Thanks a lot.

Anonymous User Report As Irrelevant  
Written: 9/8/2009 11:41 AM
i tried everything that was mentioned and this f.... piece of sh... simply has the same error Cannot find the file <path\filename.xls> (or one of its component(s)). Make sure the path and file name are correct and that all required libraries are available I HATE MICROSOFT AND THIS STUPID ERRORS IT IS FRUSTATING AND I DONT EVEN KNOW HOW IT BEGUN

Anonymous User Report As Irrelevant  
Written: 9/16/2009 9:01 AM
I repaired my MSOFFICE 2003 and reinstalled the entire MSOFFICE but in vain. Your tip worked Wonders. Thanks a million!

Dhirendra Report As Irrelevant  
Written: 9/19/2009 2:36 AM
thanks u very much boss

Steve Report As Irrelevant  
Written: 9/28/2009 11:30 AM
Excel 2003, this worked like a charm. I thought I would be stuck with this forever.

Baz Report As Irrelevant  
Written: 9/29/2009 7:20 AM
Amazing article, but what caused it, and why didn't detect and repair find it?

Anonymous User Report As Irrelevant  
Written: 9/29/2009 9:28 PM
this solves my problem. thx a bunch!

Lal - Lal Report As Irrelevant  
Written: 10/12/2009 11:22 PM
You have saved me..I have been struggling with this for sometime..Now it works fine

Clive Report As Irrelevant  
Written: 10/17/2009 8:15 AM
I agree with the guy above 9/8/09 11:41, I hate this piece of s***, none of these suggestions have fixed it for me. I get about 4 messages "cannot find file etc. etc." it splits the path name into 5 chunks, and appends .xls to each surprise surprise it can't find them. I am so p****d off with this.

GG Report As Irrelevant  
Written: 10/23/2009 7:24 AM
Thanks so much!!!!

Julie Report As Irrelevant  
Written: 10/27/2009 10:45 AM
Thank you. Worked for me. Does anyone know how that checkbox got checked? I just REPAIRED Office 2003 today, so that could be the answer for me. However, I don't ever recall seeing this problem before and I go back to 1994-ish with Excel.

Anonymous User Report As Irrelevant  
Written: 11/5/2009 8:37 AM
If you are having trouble with Excel opening a template when it's double-clicked instead of opening a new file, go to run, the type "excel /regserver" without the quote marks. This works in vista and corrects the behavior.

CESAR AGUILAR - PERU - cesar Report As Irrelevant  
Written: 11/17/2009 6:39 AM
REALMENTE FUNCIONA - MUCHAS GRACIAS

Krenz Report As Irrelevant  
Written: 12/1/2009 6:35 PM
You are life savers. I had to work all day opening my files from within excel (very slow), now everything is fine. Thanks a lot.

Sweta Report As Irrelevant  
Written: 12/4/2009 1:09 AM
Thanks a lot. It

Anonymous User Report As Irrelevant  
Written: 12/9/2009 5:23 AM
Thank you very much. Very efective solution.

Maya Ann Report As Irrelevant  
Written: 12/16/2009 8:20 PM
Thanks. It worked for me.

wilson Report As Irrelevant  
Written: 12/21/2009 10:33 PM
Thank you very much, Very quick solution, it was killing me all theses days.

JGVC Report As Irrelevant  
Written: 1/5/2010 2:14 PM
Agradezco la ayuda que me presto el sitio, quetr trabajando Super...

Bob Report As Irrelevant  
Written: 1/5/2010 10:44 PM
Baie baie Dankie

Sandy - sandrak@email.com Report As Irrelevant  
Written: 1/7/2010 8:58 PM
This did not solve the problem. My "ignore" option is already checked off. I tried checking on and saving, then leaving and coming back in and checking off, and that did not resolve either. Are there other things that might help? My husband wants to revert back to 2003, and I really don't want to do that...

JUANK Report As Irrelevant  
Written: 1/14/2010 8:51 AM
HERMANOS MUCHAS GRACIAS, SIEMPRE SE APRENDE ALGO NUEVO.

ikay Report As Irrelevant  
Written: 1/15/2010 5:14 AM
many thanks..it worked fine!

Very - Thankful Report As Irrelevant  
Written: 1/15/2010 5:02 PM
Thanks! Was driving me nuts!

RJ Report As Irrelevant  
Written: 2/1/2010 11:09 AM
That fixed it...Thank you!

Anonymous User Report As Irrelevant  
Written: 2/11/2010 10:21 AM
Thanks!

Anonymous User Report As Irrelevant  
Written: 2/18/2010 6:07 AM
thank you thank you..

Kevin C Report As Irrelevant  
Written: 2/25/2010 6:38 AM
Well done & Thanks to kbalertz - Perfect Solution

Anonymous User Report As Irrelevant  
Written: 2/28/2010 11:10 AM
Your solution worked exactly as described. Thing is, Excel used to open these files when double-clicked and I never changed that option. Anyway, thank you.

Anonymous User Report As Irrelevant  
Written: 3/11/2010 8:15 PM
thank you very much

Oscar Report As Irrelevant  
Written: 3/16/2010 2:14 AM
This worked! I just don't understand how it got checked in the first place?

Anonymous User Report As Irrelevant  
Written: 3/16/2010 9:47 AM
Thanks from Portugal. Be well.

Vic Report As Irrelevant  
Written: 3/16/2010 8:37 PM
Thanks for the Help!

(Optional) Name

(Optional) Public URL Or Email

Comments
No HTML -- Text Only Please