Windows 10: Default Excel 2003 to open all files over 2007 Solved

  1.    12 Jun 2016 #1

    Default Excel 2003 to open all files over 2007


    Hey guys,
    First time posting here.

    I have Microsoft Office 2003 & 2007 installed on my laptop and using windows 10. Laptop came with 2007 but 99% of my excel use is for work and they use 2003. So rather than downgrade (seemed silly) I installed 2003 also. Everytime I open an excel file either .xls or .xlsx it opens in 2007. Does anyone know if it is possible to set 2003 as the default program for all these files. I have done the basics like settings, default programs, but when I go to file type and find .xls & .xlsx the only programs I can set for these are Microsoft Office Excel. It does not let me choose between versions.

    At the moment I have to open 2003 and then the file. Not a huge problem but if possible would like to make 2003 the default.
    Last edited by nitro2481; 12 Jun 2016 at 11:35.
      My ComputerSystem Spec


  2. Posts : 4,767
    windows 10 Home threshold2
       12 Jun 2016 #2

    I don't have an answer for you.
    Just to remind you that Excel 2003 can NOT open xlsx files, unless you install the compatibility pack.
    Only 2007 and high versions are able to open xlsx by default.

    Why don't you just use the 2007.
    When you are ready to save the work > Office button > Save As > at Save as type, click the pointer and select Excel 97-2003 Workbook (.xls) > Save.
    That way all your office excel 2003 computers will be able to open and edit it.

    Click image for larger version. 

Name:	excel.... save as type.jpg 
Views:	3 
Size:	75.9 KB 
ID:	84763
      My ComputerSystem Spec

  3.    12 Jun 2016 #3

    You don't need Excel 2003. Excel 2007 is capable of doing anything 2003 can, and you can always save in compatibility for 2003. You can even do this with the newest 2016.
      My ComputerSystem Spec

  4.    12 Jun 2016 #4

    Main problem with that is just taking conditional formatting as an example. 2003 only allows 3. Where 2007 allows more. If I was to spend a few hours setting up a spreadsheet on 2007 to find out when I save it that some of the functions would not work on 2003 it would have been a waste of time. Yes I'm aware of conditional formatting now so therefore won't make that error but I'm sure there's a lot I could do on 2007 that would not be compatible with 2003 in work.
      My ComputerSystem Spec


  5. Posts : 4,767
    windows 10 Home threshold2
       12 Jun 2016 #5

    nitro2481 said: View Post
    Main problem with that is just taking conditional formatting as an example. 2003 only allows 3. Where 2007 allows more. If I was to spend a few hours setting up a spreadsheet on 2007 to find out when I save it that some of the functions would not work on 2003 it would have been a waste of time. Yes I'm aware of conditional formatting now so therefore won't make that error but I'm sure there's a lot I could do on 2007 that would not be compatible with 2003 in work.
    ............. Laptop came with 2007 ........................
    Is the 2007 product key also included ?
      My ComputerSystem Spec

  6.    12 Jun 2016 #6

    No it wasn't brand new. Is there a way of maybe untinstalling 2007 just keeping the the .exe file so I can install it when ever I want. Not a huge techie. Probably a silly question.
      My ComputerSystem Spec


  7. Posts : 4,767
    windows 10 Home threshold2
       12 Jun 2016 #7

    nitro2481 said: View Post
    No it wasn't brand new. Is there a way of maybe untinstalling 2007 just keeping the the .exe file so I can install it when ever I want. Not a huge techie. Probably a silly question.
    That was why I asked if you have the 2007 product key.
    I was think of uninstalling it and save the product key for later use.

    Apparently that plan of mine goes out in smoke.

    I don't think I can help you any further.
    Sorry.
      My ComputerSystem Spec

  8.    12 Jun 2016 #8

    Not to worry. Obviously cannot be done so. Thanks for your time.
      My ComputerSystem Spec


 

Related Threads
Excel files open very slowly in Software and Apps
Hi, I have installed windows 10 pro a couple of days ago and I now experience a strange behavior from excel (office 2013). I suspect this worked when booting new OS for the first time. When I open any excel file from any location on any hard...
Two days ago, Windows Update deleted my printer and its drivers from my system. I was able to get the drivers from Canon and put everything back together, but was not happy about it. Then this morning I found that another update had caused Excel...
Hi, after upgrading from Win7 Ultimate with Office 2007 to Won10 pro, every time I star Excel or Word or PowerPoint the Windows Installer screen appears and then asks for Microsoft Visual Studio Team System 2008 Development Edition.ENU disk. ...
I upgraded my laptop before attempting my main PC. On the laptop I have received an email with a simple .doc file attached. When I click on it I get the message there is a problem sending the command to the program This never happened in...
I installed Windows 10 2 days ago. I am using Excel, sometimes with 3 files open at once. If I switch over to a another program, I cannot get back to my Excel files. I have tried clicking the Excel icon in the Taskbar and then clicking the files,...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 15:33.
Find Us