Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening Excel files with 2003, not 2007 (2003 & 2007)

    I have recently loaded Office 2007 on to my computer retaining all of Office 2003 that was there before. I want to open my Excel files with the 2003 program, but when I double-click on the file, 2007 opens it. I tried right clicking on the Excel files and clicking on "Open With" to no avail. It ignores me and will not bring up 2003. I've tried that with Excel 2003 open, closed, along with 2007 open and closed - no difference. I had no problem assigning Word 2003 to open my old Word documents, but Excel does not work the same way. Any suggestions?

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Why not start Excel 2003, and open the workbooks using File | Open?

  4. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    You asked the same question in <post:=655,174>post 655,174</post:>, and the problem appeared to be solved with the help of my reply in <post:=655,203>post 655,203</post:>. I assume that doesn't work any more?

    If so, try this:
    - Select Start | Run...
    - Type
    <code>
    "C:Program FilesMicrosoft OfficeOffice11Excel.exe" /regserver
    </code>
    - Press Enter.

  5. #4
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Sorry for the confusion. Earlier that was one of the Student versions of Office. I now have the full-blown Office Pro version. The problem wasn't actually fixed before, but I worked around it by uninstalling the Student version of Office 11. Now that I have the full version, I want to solve it completely. When I do as you suggested before (and now) Excel 2003 does try to open up the document, but for some reason it takes a different path in its quest (via an old and non existant hard drive) and I get error message upon error message saying it cannot find the document, but eventually it does correctly open it. Why on earth would merely restoring Excel 2003 as the default program to open .XLS documents change how it looks for those documents? This makes no sense to me. I did at one time have my documents saved on that now non-existant harddrive, but that was several months ago. I was hoping for a different solution, but apparently one may not exist. Thank you for your response.

  6. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Check Tools | Options, General tab to see if the old, incorrect path is mentioned there.

  7. #6
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Thank you Hans for your responses. The Tools / Options / General path is correct as it is. I have always assumed that the T / O / G path is a one-way street from Excel to the files and that there is a different (hidden somewhere in the bowels) path from the files to Excel. Anyway, I'm just going to live with it the way it is as there does not seem to be a fix for it. Thank you again.

  8. #7
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Well, it has been mostly solved. Turns out that when you load Office 2007 on your computer while retaining Office 2003, one of the "shared" commands is different in 2007 than it was in 2003. I haven't been able to figure out which command nor why, but here's what happens. When you have only Office 2003 (or any other version I presume) on your computer and you double-click on an Excel file, it correctly reads the folder that you are currently in. If, however, you have both versions 2003 and 2007 installed, the later version's method of identifying your current open folder is different than the earlier version's. Excel 2007 apparently handles spaces in your folder's name differently that 2003 does. The error messages I mentioned earlier were that it could not find the folder "My" and than "Documents" etc. on down the line. I edited my "My Documents" folder to remove the space such that it's now "MyDocuments." I then went into Excel and selected Tools / Options / General and edited the Default File Location path to remove the space in My Documents and now it works as advertised. Learn something new every day.

  9. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    That's very strange - spaces in folder and file names have been allowed for more than 10 years now (starting with Windows 95), so programs should be able to handle them.
    Try the following:
    - Open Windows Explorer.
    - Select Tools | Folder Options...
    - Activate the File Types tab.
    - Select the XLS extension in the list.
    - Click Advanced.
    - Select the Open action.
    - Click Edit...
    - Compare what you see to the screenshot below. The quotes around %1 are important - they allow you to use spaces in names.

  10. #9
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Hans -

    There are no quote marks around the %1. Here's what I have:

    "H:Office 2003OFFICE11EXCEL.EXE" %1

    Another interesting thing is that when I use Excel 2007 as my intended program, it doesn't care about the spaces. Only when both are there, and I attempt to open a file with Excel 2003 by double clicking it , does this problem occur. My conclusion is that Excel 2007 altered a common command file that is used to open saved Excel files. Why? I have no idea.

  11. #10
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Put double quotes around the %1, that is what allows spaces in file names to work.
    Legare Coleman

  12. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    As I tried to imply, and as Legare mentions implicitly, you must place double quotes around the %1:
    <code>
    "H:Office 2003OFFICE11EXCEL.EXE" "%1"</code>

  13. #12
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Thanks guys. It's getting a lot closer, but there is still a small problem. My latest "Application used to perform action" is: "H:Office 2003OFFICE11EXCEL.EXE" "%1" That does indeed open the selected file without the unrecognized file names error messages and with a space in the folder name. It, however, now brings up a different error message that incidentally is incorrect and that is: "SELECTED_FILE.XLS is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen SELECTED_FILE.XLS?" YES / NO. Note that only one copy of my SELECTED_FILE.XLS file is actually open. That error I can live with because regardless of what I click, YES or NO, the error message goes away and things are back to normal. Oh well.

  14. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Have you checked that the other settings in the dialog shown in <post:=662,803>post 662,803</post:> are the same on your PC?

    Also, select Tools | Options in Excel, activate the General tab and make sure that the check box labeled "Inogre other applications" is clear.

  15. #14
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Hans -

    Sorry for not responding before this. Yes the rest of the words etc., in the diaglog box are identical. I did not have the "Ignore Other Applications" box checked. It is now. It seems to work now as it is suppose to. When I double-click an Excel file, it opens up Excel 2003 and then the selected document without any error messages. Thank you Hans for your patience and knowledge.

    IrishLefty

  16. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Opening Excel files with 2003, not 2007 (2003 & 2007)

    Hmm... usually, the "Ignore other applications" check box should be cleared, but if it works better for you when it's checked, that's fine with me.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •