Microsoft Excel

  • Thread starter IT Results Humble
  • Start date
I

IT Results Humble

When opening select Windows Excel .xls files I get the following error
message. "The file you are tying to open 'Filename.xls' is in a different
format than specified by the file extension. Verify that the file is not
corrupted and is from a trusted source before opening the file.

Basically it believes the files are text files, when in fact they are not.
This happened to a few select files after perfoming a data recovery. It
seems to have effected only the xls files that use formulas, the ones without
formulas seem to work fine.

I've tried opening in XP,03,07,Open office, excel viewers, etc. When
opening in notebad its a bunch of binary, but it has a few indicators in the
files that show me it is the excel file it's supposed to be.

I've downloaded hundreds of excel repair programs from the web to no avail.

Any suggestions?
 
B

Bernard Liengme

There are tales around that Open Office is able to open corrupt Excel files.
They can then be resaved in XLS format
It a fairly big download but it is free and might be worth trying

OR: has someone given you and Excel 2007 file but changed the extension from
XLSX to XLS?
best wishes
 
I

IT Results Humble

"I've tried opening in XP,03,07,Open office, excel viewers, etc. When
opening in notebad its a bunch of binary, but it has a few indicators in
the
files that show me it is the excel file it's supposed to be.
"

Yeah went through and tried all of that .. :(
 
A

Alexander Wolff

When opening select Windows Excel .xls files I get the following error
message. "The file you are tying to open 'Filename.xls' is in a
different format than specified by the file extension. Verify that
the file is not corrupted and is from a trusted source before opening
the file.

Basically it believes the files are text files, when in fact they are
not. This happened to a few select files after perfoming a data
recovery. It seems to have effected only the xls files that use
formulas, the ones without formulas seem to work fine.

I've tried opening in XP,03,07,Open office, excel viewers, etc. When
opening in notebad its a bunch of binary, but it has a few indicators
in the files that show me it is the excel file it's supposed to be.

I've downloaded hundreds of excel repair programs from the web to no
avail.

Any suggestions?

To get the data (not formulae), try to link to it using a new file:

[NewFile.xls]Sheet1!A1: =[CorruptedFile.xls]YourSingleSheetName!A1

and copy it down and right.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top