Cannot open excel 2003 in excel 2010 get error message


I am trying to work on excel files on Windows 7 2010 Excel and when I try to open the files saved in XP 2003 Excel I get the message
The file youa re trying to open'www.xls', is in a different format then specified by the file extension...

when I try to pen it it looks like crap
I am opening it off of a thumbdrive (double checked to make sure that the files are in fact working...they openied great in 2003)

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

It sounds as though there's something weird about the file that makes 2010 think it not a normal 2003 xls file.  Try this:
In 2003, open it go to File, Save As.  Make sure the filetype is 'Excel Workbook *.xls' (or something similar) and save it as a new filename.
Now try opening this new file in 2010.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Hi, groovymonkey.

Could you post an example of one of these files, please? (Please make sure there's nothing sensitive/confidential.)

groovymonkeyAuthor Commented:
The worksheets have been saved as .xls in 2003 (even tried to save them under the older file option...still not opening...I cannot post them as to make them sanitized I would have to obliterate everything (headings etc)...sorry...I will try tomorrow to save jsut a blank sheet in 2003 and bring it to 2010 and see if it works
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

Thanks, groovymonkey. For the sample file, it would probably be best to simply add a new sheet to one of the problem files and then delete all of its other sheets. (Not forgetting to save it with a different name!)
groovymonkeyAuthor Commented:
Perfect will try this out tomorrow...I do not have access to a machine with 2003 on it tonight
And just for your own testing purposes, here's a sample 2003 file created in 2007 (it's what I have at home).  Try that in 2010.
groovymonkeyAuthor Commented:
Okay 2003 created in 2007 worked will upload a file tomorrow...sorry got off track
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.