Solved

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

Posted on 2014-02-19
9
776 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 92

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 92

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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 92

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 92

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cascading dropdown 9 28
Looking for macro to do version saving of workbooks in Excel 2016. 6 38
Copy value from a certain cell 5 24
increment numbers by 10 11 30
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

910 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

22 Experts available now in Live!

Get 1:1 Help Now