General discussion

Locked

xls: file format is not valid

By Eminent87 ·
Hi,

We have a file server with thousand of excel file on it and every so often there's an excel file that cannot be open. It'll get the error "file name.xls: file format is not valid." I can open it up in Word and all the contents would be there but the all the format will be lost. Does anybody have any idea as to what this means? I've check on technet but they don't have anything on it.

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

xls: file format is not valid

by DKlippert In reply to xls: file format is not v ...

The problem maybe that someone has opened the file with Word and then resaved it. This is a sure way to corrupt an Excel file.

Collapse -

xls: file format is not valid

by Eminent87 In reply to xls: file format is not v ...

We only have one flavor of excel and that's ms excel 2000. The users said that they opened the same file a couple days before it got corrupted and it worked fine. This problem is very random, are there any other thing or source that could cause this?

Collapse -

xls: file format is not valid

by maxwell edison In reply to xls: file format is not v ...

You might want to look at this Microfoft article, "Error Opening MS Excel 97 File in Earlier Versions".

http://tinyurl.com/46vt

SYMPTOMS:
In Microsoft Excel version 5.0 or 7.0, when you try to open a file saved in the Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition workbook format, you receive the following error message

<File name>: file format is not valid.
where <File name> is the name of the file you are opening.

Collapse -

xls: file format is not valid

by Eminent87 In reply to xls: file format is not v ...

Poster rated this answer

Collapse -

xls: file format is not valid

by Eminent87 In reply to xls: file format is not v ...

We only have one flavor of excel and that's ms excel 2000. The users said that they opened the same file a couple days before it got corrupted and it worked fine. This problem is very random, are there any other thing or source that could cause this?

Collapse -

xls: file format is not valid

by chalejudy In reply to xls: file format is not v ...

this is a file that the header for excle is corrupt. what you need to do is set up a link to it in excel to the old file. for example
c:\file1 c:\file2.
c:\file1 cells a1:f40 have the data I want

I go to c:\file2 and in cell a1 I do the following

=[c:\file1.xls]Sheet1!$A$1

you can then get rid of the absolute reference and pull it down and to the right to get the remainder of that data. this is one method

another one is while you are in word, since you can see it in word, copy and paste it back into excel as a new file.

that file is definetly corrupt.

keep me posted

dls

Collapse -

xls: file format is not valid

by chalejudy In reply to xls: file format is not v ...

btw it is random as **** and microsoft calls it a known bug and it will not be fixed in the next version. Made me angry as I am the one;s they are coming to to get the data out of the file.

Collapse -

xls: file format is not valid

by chalejudy In reply to xls: file format is not v ...

on the word trick too keep in mind you may have to convert it back to columns if it comes in as one big piece of text.

Collapse -

xls: file format is not valid

by Eminent87 In reply to xls: file format is not v ...

Poster rated this answer

Collapse -

xls: file format is not valid

by Eminent87 In reply to xls: file format is not v ...

This question was closed by the author

Back to Software Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums