Solved

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

Posted on 2014-02-19
9
778 Views
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?
0
Comment
Question by:judico
  • 5
  • 4
9 Comments
 
LVL 93

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.
0
 

Author Comment

by:judico
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?
0
 
LVL 93

Accepted Solution

by:
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)
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:judico
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.
0
 
LVL 93

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.
0
 

Author Comment

by:judico
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.
0
 

Author Comment

by:judico
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?
0
 

Author Closing Comment

by:judico
ID: 39872480
Thanks.
0
 
LVL 93

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
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

785 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