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

x
?
Solved

Running Excel 2003 and 2010 - issues

Posted on 2013-06-26
15
Medium Priority
?
482 Views
Last Modified: 2013-07-24
I need to have Excel 2003 on my machine for an occasional work around for certain older xls files.  I have Office 2010 as my main office suite.  I was able to just install Excel 2003 by itself (in a separate folder) and after I installed it, I had to do a repair on office 2010 for it to go back to being the default.  However, my problem is this:  When I open up a file with .xls extention, it opens with 2003.  When I open a .xlsx file it opens with 2010.  I want ALL Excel files...old version and new...to open with 2010 all the time by default.  It's only occasionally where I will manually launch Excel 2003 and use the "open" command to locate an old file that I want to see in the 2003 version.  How can I get Excel 2010 back to opening ALL excel files by default (.xls and .xlsx)?  Window 7 seems to have lost the file associations feature that Windows XP used to have.
0
Comment
Question by:jbobst
[X]
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
  • 4
  • 3
  • 2
  • +4
15 Comments
 
LVL 5

Expert Comment

by:Jason Schlueter
ID: 39278847
In the control panel there is an item called "Default Programs".  Give that a shot.
0
 
LVL 1

Author Comment

by:jbobst
ID: 39278895
I've tried that...it just says "Microsoft Excel".  Even though I browse to the .exe of Excel 2010 it still opens .xls files in 2003 version.
0
 
LVL 5

Assisted Solution

by:Jason Schlueter
Jason Schlueter earned 336 total points
ID: 39282782
That seems really strange.  If you right-click the .xls file and choose "Open with...", you can specify the proper Excel executable and set it as the default.  After doing this, does it still open in the wrong version of Excel?
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 1

Author Comment

by:jbobst
ID: 39308353
There is only one Excel executable.  Not two...as you would hope to find (the two being Excel 2003 and 2010).  I can't simply tell Windows use Excel 2010 exclusively for ALL xls and xlsx files.  It just "knows" to use 2003 for xls files unfortunately.
0
 
LVL 98

Assisted Solution

by:John Hurst
John Hurst earned 332 total points
ID: 39320494
I never try to run two versions of Office in one machine. Here, where you are using Windows 7, get XP Mode (free download from Microsoft) and run Excel 2003 (or even Office 2003) in XP mode. Uninstall Excel 2003 from Windows 7 and then you will have the best of both worlds.

.... Thinkpads_User
0
 
LVL 43

Accepted Solution

by:
Davis McCarn earned 332 total points
ID: 39320565
Go to HKEY_CLASSES_ROOT\Applications\EXCEL.EXE in the registry and change the entries under shell which have "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" as a value to "C:\Program Files\Microsoft Office\Office14\EXCEL.EXE".  Don't forget to leave the trailing /e in the new entry and, if you are on a 64 bit O/S, you may need "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE".  
0
 
LVL 25

Expert Comment

by:dew_associates
ID: 39320646
You can run multiple versions of Excel within the Windows environment. This began with XP and continues through Windows 7. All you need to do is install them in ascending order - in this case install Excel 2003 and then Office 2010. Since you reversed this process, you need to run a repair.

Open the control panel "Programs and Features". Find the Office 2010 entry, select it, and click "Change". Follow the prompts to repair the installation and restore the file associations.
0
 
LVL 25

Expert Comment

by:dew_associates
ID: 39320652
I misread your post - sorry. Are you capable of editing your file associations in the registry?
0
 
LVL 25

Assisted Solution

by:dew_associates
dew_associates earned 332 total points
ID: 39320668
If you're not, then you may want to have a look at this:

http://defaultprogramseditor.com/
0
 
LVL 14

Assisted Solution

by:Zack Barresse
Zack Barresse earned 332 total points
ID: 39321421
It does sound like a file association issue.  Have you tried a repair?  You should run this on 2010.

Usually the last installed version will be what's used when you double-click on a file, unless you already have a previous version open, in which case it will try to hook the open version and use that (when you double-click).

If a repair doesn't work I would think about uninstalling/reinstalling 2010.  Or deleting all file associations and re-establishing them from scratch, but this is taken care of in an install, and should be done in a repair as well.

Regards,
Zack Barresse
0
 
LVL 46

Assisted Solution

by:aikimark
aikimark earned 336 total points
ID: 39322243
1. open a directory with a 2003 workbook in it.  
2. right click on the .xls file and choose Properties sub-menu item
3. Click on the default program button.  This might not be on the original tab on the dialog window.
4. select Excel 2010 icon
5. close the windows
6. double click the .xls icon to verify that it works.
0
 
LVL 1

Author Comment

by:jbobst
ID: 39351885
aikimark, tried that, there is only one Excel icon...that is my problem...that Windows doesn't distinguish between Excel 2003 and 2010.  I can't choose the default "open with" when it comes to xls and xlsx files.

firefytr, I did run repair and reinstalled didn't make a difference.

drew_associates, I can modify my registry, what registry entries should I edit?  I suppose a third party tool might work, but I haven't tried the one you suggested.  I was hoping for a more standard method.  After all, Microsoft did build all three software products (Windows and both Excel versions).  As mentioned, I did run repair...and that made 2010 be the default for both file types.  I can open Excel 2010 and use the file/open command and browse to a 2003 file version and it opens in 2010...but not by default.

Maybe the way it is, is the way it's designed and there just isn't a work around.  The main problem seems to be that file associations just aren't the same in Windows 7 any longer.  The fact that using the "open with" option ONLY gives ONE instance of Excel seems frustrating.  Windows SHOULD be able to tell that there are two version of excel, and two different file extensions, and allow me to decide how I want each file type to be opened.

At this point, we can live with this, so I am going to assign points and close the question.  Thanks for all the help.
0
 
LVL 1

Author Comment

by:jbobst
ID: 39351894
I some how missed DavisMcCarn's solutions.  I will try those registry changes.  Thanks!
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

671 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