Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


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

Posted on 2014-02-19
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
LVL 97

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 97

Accepted Solution

John Hurst earned 750 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)
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.


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 97

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 97

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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

721 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