Office & Productivity Software forum

General discussion

Unable to open Excel 2003 files with Excel 2007

by Clifford Francis / June 14, 2009 12:31 PM PDT

I have recently installed Excel 2007.My OS is windows Vista
I am unable to open excel files of previous versions directly by clicking. To open a previous version file, I have to open Excel 2007 first, then click file open and then browse which is time consuming.
What should I do to be able to directly open previous version files directly?

Post a reply
Discussion is locked
You are posting a reply to: Unable to open Excel 2003 files with Excel 2007
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Unable to open Excel 2003 files with Excel 2007
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Re: Opening .xls files
by Kees Bakker / June 14, 2009 5:31 PM PDT
Collapse -
Unable to open Excel 2003 files directly by clicking on the
by Clifford Francis / June 15, 2009 12:11 PM PDT
In reply to: Re: Opening .xls files

I have Windows Vista OS and Office 2007.
I am unable to open Excel 2003 files directly by clicking on the file with Excel 2007. I checked the 'Set Associations' tab and the default for 'xls' files is Excel 2007. So it seems there is some other problem. Surprisingly I dont face this problem with Word or Powerpoint where I can easily open files of earlier versions directly.

Collapse -
Looks good ...
by Kees Bakker / June 15, 2009 8:09 PM PDT

but apparently isn't.

Things to try:
1. Associate .xls with, say, Word, then immediately back again.
2. Repair install of Office 2007.

Sorry, no more suggestions.

Kees

Collapse -
Unable to open Excel 2003 files directly by clicking on the
by Clifford Francis / June 16, 2009 9:47 PM PDT
In reply to: Looks good ...

Thanks Kees!

Tried both the things you suggested.
I associated xls with Microsoft Works Spreadsheet, and it is working but when I come back to Excel 2007, it is not opening.
I am not getting any error message.
Its a real mystery.
Can you suggest something else

Collapse -
What happens when you try?
by MarkFlax Forum moderator / June 16, 2009 7:00 PM PDT

You say you are unable to open Excel 2003 files in Excel 2007. What happens when you try? Any error messages?

What happens if you 'right click' the excel file, then choose Open, or right click the file and select "Open with..", (assuming that option is still available in Vista)?

If they don't work, what error messages do you see?

What happens if you open Excel 2007, navigate to the file and open it, then "Save As" the file, (using a different name to prevent over-writing the original)? If you close down Excel 2007 afterwards, can you then open that file directly by clicking?

If not, what error messages do you get?

Mark

Collapse -
Hi
by Clifford Francis / June 18, 2009 7:31 PM PDT

I do not get any error messages.
Tried all the things you suggested.
Can you suggest something else

Collapse -
Unable to open Excel files by clicking on it
by Clifford Francis / June 19, 2009 6:04 PM PDT
In reply to: Hi

HI,
My OS is Vista.
Previously I had Office 2007.
I was unable to open Excel 2003 files by directly clicking on the file Icon. I had to open Excel 2007 and from the open tab, browse and open Excel 2003 files.
I then uninstalled Office 2007 and reinstalled Office 2003.
But still I am unable to open Excel 2003 files by directly clicking on the file Icon.
Its very frustrating.
Can you tell me what could be the problem

Collapse -
Please tell ...
by Kees Bakker / June 20, 2009 5:41 AM PDT

- the full details of the file associations OPEN command (alas, I don't know if that's possible in Vista)
- what exactly happens if you (doubleclick) an .xls file (just "unable" doesn't tell much)
- same as above (2 questions) for a .csv fike
- same as second question if you choose Open with ..., then Excel from the right click menu
- if it works after booting in Safe Mode

Kees

Collapse -
Unable to open Excel 2003 files directly by clicking on the
by Clifford Francis / June 21, 2009 5:45 PM PDT
In reply to: Please tell ...

the full details of the file associations OPEN command - The file association for .xls and .xlsx is Microsoft Excel 2003(now)
- what exactly happens if you (doubleclick) an .xls file (just "unable" doesn't tell much) - The hour glass starts and after a few seconds just fades away
- same as above (2 questions) for a .csv fike - dont have any .csv files
- same as second question if you choose Open with ..., then Excel from the right click menu - - The hour glass starts and after a few seconds just fades away
- if it works after booting in Safe Mode - No it doesnt work in the Safe mode too

Collapse -
Re: open with Excel
by Kees Bakker / June 21, 2009 5:55 PM PDT

Not exactly what I wanted to know with "full details", but you couldn't know that.

My full details:
Program used: "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e
Use DDE: yes
DDE message: [open("%1")]
Application: Excel
Subject: system

What I should try in your case: uncheck the DDE checkbox and change the first line to
"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" %1

Hope this helps.


Kees

Collapse -
Hi
by Clifford Francis / June 21, 2009 10:33 PM PDT
In reply to: Re: open with Excel

Didnt understand.
Where exactly do I change it.
Can u elaborate please

Collapse -
Re: editing file associatons
by Kees Bakker / June 21, 2009 10:40 PM PDT
In reply to: Hi

in XP it's easy: from Control Panel>Folder Options, search xls, click advanced, choose open, click edit.

In Vista it seems you need a third party tool: http://www.annoyances.org/exec/show/article02-500

I've got the impression that somehow your DDE (part of Vista) doesn't function. So this is to test that assumption. If we know that that's the problem indeed, your choices are:
- live with the problem as it is
- accept the non-DDE way of working
- do a repair install of Vista to get DDE working again
- do a clean install of Vista to get DDE working again
But first we need to know that that's the issue indeed.

Kees

Kees

Collapse -
Unable to open Excel files directly by clicking on the file
by Clifford Francis / June 22, 2009 3:57 PM PDT
In reply to: Re: open with Excel

Thanks Kees!
You are a genius.
Used the creative element method to change the file association
Thanks Again

Clifford

Collapse -
(NT) You're welcome.
by Kees Bakker / June 22, 2009 7:28 PM PDT
Collapse -
I see I am going to have to read up on DDE, etc
by MarkFlax Forum moderator / June 22, 2009 7:50 PM PDT
In reply to: You're welcome.

I've been following this discussion with interest, and it's good to see the problem solved.

But I have no idea how. I need to learn more! Happy

Mark

Collapse -
What do I need to do?
by thomasm56 / December 9, 2009 4:42 AM PST

I have recently installed Excel 2007.My OS is windows Vista
I am unable to open excel files of previous versions directly by clicking. To open a previous version file, I have to open Excel 2007 first, then click file open and then browse which is time consuming.
What should I do to be able to directly open previous version files directly?

Collapse -
Do the same as the poster above.
by Kees Bakker / December 9, 2009 6:21 AM PST
In reply to: What do I need to do?

Might help.

Kees

Popular Forums
icon
Computer Help 47,885 discussions
icon
Computer Newbies 10,322 discussions
icon
iPhones, iPods, & iPads 3,188 discussions
icon
Security 30,333 discussions
icon
TVs & Home Theaters 20,177 discussions
icon
HDTV Picture Setting 1,932 discussions
icon
Phones 15,713 discussions
icon
Windows 7 6,210 discussions
icon
Networking & Wireless 14,510 discussions

Tech for the school year

Smart tech for smart students

Forget the pencils and notebooks. Gear up your students with these portable and powerful note-taking machines.