Feeds:
Posts
Comments

Archive for April, 2010

I have experienced this problem myself from time to time. For some unknown reason, double-clicking an Excel file (.xls, .xlsx, etc.) in Windows Explorer (My Computer, whatever)  does not open the file. It opens Excel with a blank workbook, but the workbook you clicked on is not loaded. If you leave Excel open and double-click the file again, it will open just fine. If, however, you quit Excel completely, then double-click the file again… you’re back to the original problem.

After much investigation and aggravation, I’ve finally decided upon a solution that fixes this problem… although I really can’t say for sure why it fixes the problem!

First of all, let me say that I’m a total Excel minimalist. I will not load an add-in, DLL, or module that does not have an immediate purpose for existing. I never attach the “Analysis Toolpak” or “Solver” add-ins unless I know I’ll be using them (and I do use them occasionally). After I’m done using them, I detach them. Having said that, it appears that this lack of add-ins may be part of the problem.

The solution I’ve found is to open Excel and attach one of the common add-ins (I usually use Solver), then quit Excel. After that, the problem miraculously goes away!  I can go back and detach the add-in, and the problem is still resolved.  Go figure.

Six months later, the problem resurfaced again. No idea why.  So, I just detached all my add-ins. Quit Excel. Restarted Excel, re-attached the Solver Add-in. Quit and restarted Excel one more time. Problem solved again.

—————————————————–

As an additional service, let me review the solutions that did NOT work, because you’ll problem come across these while web surfing for solutions:
 
1. De-select the “Ignore other applications” option on the “General” options tab – One of the “official” Microsoft knowledge base solutions. While this may work under certain circumstances, it was absolutely useless to me because I didn’t have this option selected to begin with.
 
2. Excel /unregserver, then /regserver – Another option that I find useful on occasion, when needing to reset command bars and menus back to default condition. But for this particular problem… useless.
 
3. File Association settings – In Windows Explorer, right click an Excel workbook file and select “Open With… Choose Program…” In the next dialog, pick the Excel program and check off “Always use the selected program to open this kind of file”. This solution was concise, logical, and seemed a perfect way to resolve the exact problem I was having…   Nope, didn’t work. On to the next one…
 
4. Mess with the “File Types” settings in Windows Explorer (Tools… Options… File Types tab) – This is the first one that attracted my attention because it seemed so coherent and the posting had dozens of replies saying thanks for the wonderful solution, it worked like a charm, etc. Well, my advice is to steer well clear of this one unless you really know what you’re doing. This solution requires you to make changes to the Registered File Types settings so, being a careful guy, I made detailed notes of the current settings and then implemented the new recommended settings. It fixed the problem, but created a new one. Now it was opening the file on double-click, but then (I think) trying to open a second instance of Excel and, finally, causing Excel to crash! So, I went back in to the File Type settings and put everything back just the way it was, but it didn’t fix the Excel crashing problem. It took another hour of research and manual registry editing, to get it back to its original state.  Avoid this solution. It’s not worth the aggravation.
Advertisements

Read Full Post »