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 90

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 90

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)

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.
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

LVL 90

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 90

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now