Can't Open Excel 2010 File (Under Windows XP) by Double Clicking On It

Posted on 2014-02-19
Last Modified: 2014-02-20
Suddenly a problem occurred when I try to open an Excel 2010 xlsm file by double clicking on it. I can open the file from within Excel but not by double-clicking on it. I tried the usual suggestions such as:

Unchecking File->Options->Advanced->General->Ignore other applications that use Dynamic Data Exchange (DDE)

Open With Excel, checking 'Always use the selected program to open this kind of file'

excel.exe /unregserver and then excel.exe /regserver

I repaired the Windows XP and reinstalled Excel.

When opening it from within Excel I saved it under a different name.

Nothing worked. Also, took a look at the questions in experts-exchange concerning this issue and didn't find the answer there either. Something is wrong with the file association but I don't want to solve that by making a new profile. Do you have an idea how this problem can be resolved?
Question by:judico
  • 5
  • 4
LVL 94

Expert Comment

by:John Hurst
ID: 39872250
Did you even try a new Windows Profile?  Profile corruption in XP causes Office not to work properly - I have seen that numerous times.

Please determine if a new profile solves the issue, because if so, no amount of Office uninstall/install/repair will fix it.

Please let us know.

Author Comment

ID: 39872289
I tried opening the Excel file under a new profile but a bunch of error messages appeared before it finally opened up. I'd really like to fix the problem without creating a new profile because a number of other issues pop up with a new profile. Should I try uninstalling Office and then installing it again?
LVL 94

Accepted Solution

John Hurst earned 250 total points
ID: 39872296
If a new profile causes issues (that does not usually happen) and if you have repaired XP, then the likelihood now is that the base operating system is corrupted and not repairable.

If you wish to invest the time, you probably need to reinstall XP (not much more time than creating a new profile which did not work anyway).

Is it time to move on from XP?  (Rhetorical question)
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center


Author Comment

ID: 39872308
I like Windows 98 the best. Unfortunately, had to move to XP. I also have 7, which is OK but is much heavier and clumsier than XP (I'm using Windows through Parallels on a MacBook Pro). Windows XP is the OS under these circumstances. Have tried 8 but that's out of the question.

If I reinstall XP I'll lose everything, which I try to avoid. The only option is to try to repair it again (in this way I'm only losing files in C:\ outside the folders but I've provided for that). Clean install will bring about innumerable additional issues. Some other, conservative way, must be found.
LVL 94

Expert Comment

by:John Hurst
ID: 39872325
Windows 98 is thankfully dead and gone. XP is dead and not far behind.

I have a Windows 7 Pro 64-bit desktop that works fine. I do not find it clumsy at all. It is much more secure than XP and can handle a bigger workload. 64-bit can handle more memory and Windows 7 can handle bigger disk.

My ThinkPad X230 here is a Windows 8.1 Pro 64-bit machine that I am beginning to like as much as or even better than Windows 7. I only use the desktop (NEVER Metro) and Windows 8.1 starts right to the desktop. I am replacing the Desktop with a Windows 8.1 machine.

Back to your XP machine, once it is beggared up, and repair won't fix it, then clean install is the only hope. Clean install has never (in my experience) brought innumerable new issues.

Still, it really is time to move one.

The only real issue with Windows 7 or 8 compared to 32-bit XP is the need for new software. Office 2010 works great on Windows 7. I use Office 2013 on Windows 8. Adobe needs to be newer along with other software, and likely the machine itself must be replaced.

Author Comment

ID: 39872353
The need for new software is a big issue because, almost as a rule, the new software is worse than the old. Take Adobe Acrobat -- the best version was 4.0. Every next version brought about deterioration in performance (the distilling, for instance). I know that these companies have to make money but that shouldn't be done by destroying the already available technology. As for Windows 7, that's fine indeed but, for instance, the load time through parallels is much longer. I'm using the top possible 17" Retina MacBook Pro and still Windows 7 is an issue. As for Excel 2010, it's better than 2007 and that's one of the nice exceptions to the rule. Regarding the clean install of Windows XP -- it will bring about plethora of fine tuning activity let alone re-installing of all kinds of software. However, if that's the only option then be it. Working with computers needs sacrifice.

Author Comment

ID: 39872361
There's another option -- to leave as it is and keep opening excel files from within Excel. That works just fine. What do you think? In your experience have there been more and more issues appearing down the line?

Author Closing Comment

ID: 39872480
LVL 94

Expert Comment

by:John Hurst
ID: 39873002
There's another option -- to leave as it is and keep opening excel files from within Excel

You can certainly do this. At some time you will need to replace things and until then opening the file from Excel will work.

Thank you

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

828 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