Opening Excel Files From Windows Explorer
As I’m sure you know, you can double click on an Excel file in Windows Explorer to open it in Excel. Sometimes this causes a problem, however. Typically, the problem encountered is that the file doesn’t open, but Excel opens with a blank area where the workbook should be. If you encounter this problem, the first two things you should do are:
1. Tools>Options>General and uncheck Ignore Other Applicaitons.
2. Close Excel and from Windows use Start>Run. Type in
C:\MyPath\Excel.exe /unregserver
then do the same thing, but type
C:\MyPath\Excel.exe /regserver
Replace MyPath with the actual path to Excel.exe. Neither of these commands will start Excel, but they will rewrite the registry items associated with Excel. I’ve never had to type the path, I’ve just used
Excel.exe /regserver
but better safe than sorry. And thanks to Dave Peterson for the /unregserver tip. Sometimes just using /regserver will fix the problem, but there have been occasions when the /unregserver step was needed.
I had problem with the excel file , when opening from windows 2000 explorer. This solution really helped me
Thanks Dick Kusleika
You’re welcome, Sridhar.
Thanks! I was going crazy with this problem and this solution fixed it! Thanks a lot!
I tried this option, but still I receive a message “Cannot find the file “abc.xls” (or one of its components). Make sure the path and filename are correct and that all required libraries are available.
Excel.xls file is on the server but its giving bank screen ???? can any one tell me..
there is no error
very nice….fixed an issue i was having. thanks for providing the regserver command.
Thanks so much, this was driving me crazy… whenever I opened a file from windows explorer in excel it would rename the file and forget where it came from. This fixed it! Thanks!!!!
“Cannot find the file “file.xls” (or one of its components). Make sure the path and filename are correct and that all required libraries are available
Thank you very much.
This problem came up for me recently and was quite inefficient and annoying when you handle excel files all day.
The solution suggested here fixed it. It took me a few minutes to get the path configured correctly.
I believe there needs to be a space between the colon and the beginning of the path description. For example on my computer it was-
C: Program Files\Microsoft Office\Office10\EXCEL.EXE/unregserver.
Dick - It’s actually a forward slash, but for some reason my blogging software can’t escape a forward slash. It should be c:\Program Files… (we’ll see if that forward slash shows up)
That has been a constant source of irritation for some time now and life is too short! Thank you so much.
Thanks…:)
It worked well…
Rajesh
It was good r&d
I would like to have more info about the troubleshooting windows os and application s/w
Thanks
For a bit more about troubleshooting Excel, see:
http://www.jkp-ads.com/Articles/StartupProblems.htm
Thank you. It was a irritating problem. It disappeared after I did uncheck.
Thanks, was waiting for my IT person to fix this. Just found your info and it works… Highly recommend
That is some good info!!!
Mine finally worked with just Run=>
“excel /unregserver” and then “excel /regserver”
with a space between excel and the slash
Thanks my smile is back above horizontal now
Thanks and step 1 fixed this annoying problem.
Do you know hwta causes it? Thanks again.
1. Tools>Options>General and uncheck Ignore Other Applicaitons.
Nice! Worked for me too. I was looking for a fix to this for a co-worker.
thanks for you helps … quick and simple yet straight to the point..
thanks
This was an absolutely fantastic fix for me. I have tried the unregistering and registering of excel before and it didn’t work - the “ignore other applications” combined finally did it. I had been searching for solution for ages. Many thanks.
Thank you very much! Your fix worked. Its a shame microsoft does not have answers for these type problems.
Great tip… finally I’ve gotten this working.
Had to plead with centralised IT support for an admin passport just to be able to place run on my start bar.
Now they’ve given me one - I’ve run riot and fixed numerous bugs.
Thanks for the help - very much appreciated!!!
hi,
when i am trying to open excel file on dubble click.
it taking so much time to open. but when i open same file from file menu—->open it open quickly.
i reinstalled ms office but i still facing same problem.
pls help me out of this problem
thanks
pradeep
I wish I found this before I went through the pain of uninstalling and reinstalling Office 2003. The “unregserver” tip worked famously. I’d be curious to know why and how this happens “all of a sudden.”
Thank you so much!!
I have tried the /unregserver and /regserver but it still did not fix the problem. I have also examined the XLS file type which appears correct.
If I add the {pathname}excel.exe in front of the xls file from a short cut it opens with out an error.
Thanks!
Worked perfect!
Your fix worked GREAT. It saved me from rebuilding a profile. THANKS!!!!!
Works great!
Unreg and regged the first time with no success.. Did Microsoft Office update to no avail.
Tried this in Options, and worked right away.
Using Office 2003
This is somewhat related to th eproblem for some people and may explain a bit more.
I think I have figured out this stupid Excel thing.
Excel has this bast%^%^ized MDI SDI thing.
I think most people run Excel with it’s child Window Maximized (which makes it really confusing).
So when you click on another file it switches to that file, hides the other window but adds another icon on your task bar giving you the feeling you started another instance of excel (but it didn’t !!). I’ve been burned by this too many times and shutdown what I thought was one instance of excel turned out to be all of them. Word does not behave this way.
So there is an option to disable this feature called “Ignore Other Applications” (under Options-> General). If you look at the help on this it basically shuts of DDE. What DDE basically does is when you click on a file it checks to see if Excel is already running and if it is, it passes the file to that already running instance. The problem with turning this switch on is the file mappings that are already installed assume DDE is on and things break. So when you shut that option off you suddenly start getting errors that Excel cannot find the file.
To fix this go into your File Explorer (My Computer) and Choose Folder -> Options -> File Type. Find XLS and select it, then click advanced button. Now Select the “Open” Action and choose Edit button. Now this is the trick, shutoff DDE by unchecking it. Then edit the end of the action. The end should be something like this (note the “%1″) and note there must be a space between the /e and the first quote.
“C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE” /e “%1″
Now this allows you to create a SEPERATE instance of excel everytime you click on an Excel file. And when you close that excel instance it has no impact on any other. It also gets rid of the I can’t find the file problem. In some cases you will see a %1 without the quotes. That causes the problem that excel can’t find files when the path has spaces in it.
You may want to repeat this for other files types that maps to Excel. Like .CSV
If you have “ignore other applications” switch unchecked (default behavior) you get the funky SDI/MDI/Excel Instance behavior.
If you have “ignore other applications” switch checked, you get the more logical MDI/SDI/Excel Instance behavior but the file type mappings must be fixed as I described above.
This all assumes under WinXP.
Why would you want a separate instance of Excel for each workbook you open? Is it just confusion over the View Windows in Taskbar setting? You’re better off unchecking View Windows in Taskbar, so you only see the instance of Excel, and not each workbook window. For the rare case in which you need another instance of Excel, simply start Excel from the Start menu.
IMO, the MDI/SDI/Whatever behavior in Excel is much better than that of Word. When 2000 came out, you couldn’t change the Windows in Taskbar behavior of Word, and that made me nuts. Also, Word forces one set of menus atop each document window, not on the application window, so when you arrange windows, you get two or more blocks of UI taking up vital visual work space.
MSWlogo-
THANK-YOU VERY MUCH FOR YOUR TIP!!! I have been fighting with this stupid Excel to open a separate window each time I double-click on an .XLS file. To Jon Peltier above, I spend all day opening and closing Excel files and want to close one file but leave the other open, only to find I have closed them all because they appear in one window- and by the way lose the work I spent typing and pasting in data from the other files. You would think Microsoft would put an accessible switch in the options area to flip between SDI and MDI to accomodate everyone.
RST
Hey, thanks a lot.
Result!
Tommy
Works for me. Great stuff. Thanks for making this knowledge available - been trying to fix the “Excel starts up empty” problem for months.
Hi Mr. Dick Kusleika,
Thank you for providing this solution as this really helped me and resolved the issue which I was facing since the last 2days.
Thank you once again!
Have a great time!
Cheers,
Dev.
Very nice. Thanks a lot. I’ll remember this page!
It worked!!! Thanks so much. This issue was annoying for so long. Key things to note–you need a space between the colon when you type C: \”mypath”\excel.exe/unregserver, where “mypath” is the exact location of your excel program (for me it was “\Program Files\Microsoft Office\Office\excel.exe”)
Thanks again!
Great solution for muliple instances! Thanks.
your suggestion helped me in opening the excel file. good, keep it up. thanks Ravi
I dishoped to find back this such more convenient setting. For info, I used to enjoy this feature with Excel 2000 in former times, until it suddenly went away. When installing Office 2003 a few weeks ago, I had the pleasure to see it again, until it faded away, again without any explanation.
Thanks a lot for this great tip to run multiple Excel instances !
Great tip, I used it for word too!
Katy
Works on Excel 2007 (Beta 2) as well (Ignore other applications is now listed in the advnaced section)
Thanks , it works !
it worked for me too guys try it out !!
thansk a lot
I have looked all over the web, and nothing else worked. So I just gave this a shot, and it worked. Thank you very much.
Thank you - this fixed the problem. The /unregserver piece was the part I was missing.
Hi everybody,
Regards this issue, I had found out a strange phenomenon. Let say I have a pre-opened Excel E1 by using Microsoft Excel 2003 (blank document is also OK). And I open another Excel file E2 but using Internet Explorer 6.0 in this way:
1. Page “parent.htm”:
2. Page “child.htm”:
function test_onclick() {
window.open(”test.xls”,”_self”);
}
No matter what “test.xls” is. (It can be an empty Excel file).
Now when I open the “parent.htm” and clik on the non-Excel frame, the Excel file E1 WILL BE LOCKED (you can’t do anything except closing it).
Do you have any idea on this?
Thanks,
Chanh.
The comment 31 from mswlogo is really good. Sometimes you have two monitors and you want to compare two EXCEL files. Then you will know how helpful this tip is. Thanks a lot!
Thank you - this fixed the problem. The /unregserver piece was the part I was missing.
Thank you
Thank you
Thank you
mswlogo
THANK YOU very much for the solution to the multiple instances problem.
Very well introduced and explained.
I cant uncheck the Use DDE box. That is, I uncheck it, click Ok, Ok, and Excel still opens in the same instance, I go back to the folder action settings, and it is back to having DDE checked!!!
Great solution was stumped at this for a while.
Cheers
Ahhhh..
whew.. yet another constitution saved from terminal insanity.
Y’next brew’s on me.
Cheers..
Thank you for your post mswlogo! You helped me solve this problem for someone.
Thank-you so much! The Excel MDI experience has bothered me for years. The Excel UI is just not designed to properly accommodate a true MDI interface. Wait until you get a load of Excel2007, it’s even more akward than ever!
Now I can finally double click on two files directly and compare them side by side on my DUAL MONITORS, something that was always a pain to do before. (open one, go to start menu, find it there, open it, wait, file, open…. finally!)
Now, is there any way to get ride of the “Microsoft Excel” in the task bar buttons? I know what program it is, I can see the icon!
To get rid of the “Microsoft Excel” in the title bar (and show only the workbook name) execute this VBA statement:
application.Caption = ” ”
That’s a space between the quotes. Using empty quotes resets it to normal.
Re:Point 31
I like the way Excel works already. I stack up Excel applications when I need them and separate them so that if I want to link excel files or just Ctrl+F6 between them I keep them together and if I think one file is big slow and unstable and is at risk of crashing I open it up in an independant application so that I can kill separate “Excel’s” without trashing my other work.
I would hate for Excel to start to behave like Word.
JK -
“I like the way Excel works already.” … “I would hate for Excel to start to behave like Word.”
Me too.
Thank you so much for your hint! I was going crazy with this error!
Thank you so much. I have been looking for a way to open new instances of Excel every time I double click the files for a long time. I am not sure what the advantages of MDI in Excel are such that Microsoft made this the default behavior.
I have dual monitors and need to look at two spreadsheets on separate monitors. MDI just can’t manage this very well (esp when monitors are of different sizes).
Appreciate the info! I was fine until inducing the problem by turning on the “ignore other applications” trying to help someone else. Turned it off again but the problem with split file names remained.
I have a different problem opening with Windows Explorer. When opening a file from Windows Explorer when I have Excel already open with a file active, the active file is deleted and the new file loaded up. Excel doesn’t give any warning nor does it ask if you wish to save the file. I have replicated this on both my desktop (Windows XP Media) and laptop (Windows XP Home) using the same software–Office 2003. Have you heard of this problem? Any solutions?
Thanks,
Jimmy Griffith
Thanks for your help Dick Kusleika. The solution you suggested worked. Your instructions were very clear too. Thanks. James
Thanks a lot, this option is working fine for me.
Thanks alot of this handy tip. It helped me solve a problem ive been having for a few days..
Thanks a lot! It was very helpful this advise!
Holly Molly - I can take my foil hat off, thought they (gov space people) finally had me that time.
Thanks a lot. I can start excel files again via double click. However, it occured already after unchecking the Ignore other applications. Then comes the strange part…
When I now try to run C:\Program Files\Microsoft Office\Office\EXCEL.EXE /unregsever, I get the error Cannot find the file ‘C:\Program’ (or one of its components). It seems the RUN command does not recognize the space in “Program Files”… Any idea how to solve this problem? With excel I don’t have problems with dirs or files having blanks.
Thanks for the advise. It really helped me.
Thanks a ton for this! My new work laptop was choking on opening XLS, and this totally fixed it!
Jimmy: If you look in the Window menu, isn’t your previous file still there?
Could there be an addin or a macro somewhere else that causes havoc?
Andre: You need to put the entire string in quotes except the startup parameters:
“c:\program files\..\..\Excel.exe” /unregserver
In regards to the Application.Caption = ” ” to shorten the names in the task bar, I get Invalid outside procedure. Is this due to missing admin rights?
Although the registry method worked for me the results were temporary. Scotty’s advice led me to figure out where the problem was. I tried it and found it worked, but again only good for one more opening of my Excel file and suspiciously, the execution of a macro. I decided to turn the Excel macro recording on and took a look at what was recorded with Scotty’s method. It was Application.IgnoreRemoteRequests = False. Sure enough, I had a macro running that turned them true but did not turn them false so I just pasted the recorded macro on the end and problem solved. Not sure exactly why it worked but it probably has to do with what IgnoreRemoteRequests means. I used it to suppress the clipboard prompt that you often get in Office products but admittedly it was a bit of a hack-job. Just glad that I can now roll on. Great to have the help.
I have similar issue with Excel 2007 opening Excel 2003 files. any path with a space Excel 2007 doesn’t like. I have some workstations that work fine. I have narrowed it down to a %1 on the end of the application path. The workstations the work correctly don’t have the %1. I find this under folder options, file types, xls, open, edit, application path. I have tried everything and can’t remove the %1. I delete it, try to open a xls document and it still fails. I go back an look and the %1 is there. I tried /unregserver and /regserver and still no fix. How do I permanently remove the %1?
One thing we found to “fix” this issue is to go into File Types, XLS, Advanced and make “New” the default instead of “Open”
Excel opens empty.
I couldn’t get rid of %1 either. I ran an Office 2007 repair and that fixed that but I cannot get /unregserver /regserver to work. I go to Run and type the path: C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /unregserver but it says that it cannot find ‘C:\Program’ I put the whole path in Quotes, followed by the switch, and it just opens EXCEL. I follow up with the /regserver switch, after the quotes, and it opens EXCEL again but still opens empty until I click open-cancel or minimize, then it brings up the doc. Ignoring other applications doesn’t help either. What are you folks doing differently? thanks!
sorry. I read half way the messages then skipped to the “end of the book” and typed my comments to a post then I learned afterwards that others were having the same syntax issues. Sorry for the double post. Neverhteless, the problem remains. Thanks for any helpful comments that may be directed my way.
well, “1%” works, but creates several instances of the program with many other problems. If /regserver do not work try http://support.microsoft.com/kb/918165 “Problems in Windows Explorer or the Windows shell after you install security update MS06-015″.
Only reapplying the update help me finally get rid of the delays
Thanks this fixed a truly irratating problem with word too. Thanks again.
Steve
If you have Nokia telephone and the problem started after October 2007, than the most probable reason is Nokia PC Suite version 6.85.14.1 or 6.85.12.0 installed. At least I finally resolved the issue with long time opening files on Dell 620 with Toshiba BT, Win XP Prof SP2 by downgrading PC Suite to version 6.84.10.3.
Full thread is there -> http://discussions.europe.nokia.com/discussions/board/message?board.id=pcsuite&thread.id=22808
mswlogo,
Your solution worked like a charm!!! Thanks dude!
Cheers mate!
HI
I had this problem and I tried to uninstall and re install my office several times, but the problem still remained.
Your method solved it in seconds
Thanks
I had a problem with opening excel files which had a space in the path, not file name. The settings were all correct in folder settings, but only was fixed by the regserver.
Thanks!!
Thanks for this solution. I was facing too much problems as my files are interlinked and was not able to work on them.
Thanks once again
Sudhir
thanks - it worked for me!
Gianluca
mswlogo,
I switched to excel 2007 a few months ago and never had issues opening files but suddenly last week I started getting failures on .xls files. If the path had spaces it failed to open the file. This was driving me crazy so today I decided to google the issue. This page was my second hit. It looks like I lost the ” around the %1 - no idea how. I added them and bingo!!!! it works!!!!. Thanks mswlogo!
J.
thanks a lot, worked for me so far. But one more thing, extending that issue: in my understanding I would have to register each file type individually. Usually this is also possible via right-click, “open with..” etc. But the Excel icon does not appear in this list, and if I browse for it it is not imported either. Does anyone know how to solve that? I have lots of different file types and changing all manually will be painful….
Occured for me after installing Office 2007
Thanks,
Manolo
Thanks! Really appreciate the clear instructions, very helpful!
Thanks a lot. It solved my problem.
Great! It worked. The quotes around the %1 did the trick ( “%1″ ).
turning off the “ignore other applications” did the trick for me.
Thanks.
Thanks. Complete the task with the 1st step itself.