I have an extremely important xls Worksheet file, which of
course, no back up was made. I am trying to fix it for somebody but I
keep
hitting dead ends. I have Excel 2003 here, but if I try opening it up
in
any version it comes up with the error "Unable to read file". I am
just not sure where the 'corruptness' of the file is. What would make
my life easier would be a program that would
automatically fix an Excel file.. but if theres not does anybody know
where
I might find information on the XLS format?
Thanks!
Alan - 24 May 2008 15:20 GMT
> I have an extremely important xls Worksheet file, which of
> course, no back up was made. I am trying to fix it for somebody but I
[quoted text clipped - 9 lines]
>
> Thanks!
Hi,
I think you can try a utility called Advanced Excel Repair to repair
your Excel xls file. It works rather well for my corrupt Excel xls
files. Its web address is http://www.datanumen.com/aer/ Hope this
helps.
Alan
Don Guillett - 24 May 2008 16:00 GMT
Did you try open office? Just yesterday, I inadvertently had a udf and a sub
named the same and 2003 and 2007 would just freeze. Fixed.

Signature
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
>I have an extremely important xls Worksheet file, which of
> course, no back up was made. I am trying to fix it for somebody but I
[quoted text clipped - 9 lines]
>
> Thanks!
Gord Dibben - 24 May 2008 16:39 GMT
What is the rest of the error message?
Excel should give more info about why it is unreadable.
Could be as simple as not having double quotes around the path in your shortcut
to open.
"C:\your path to file folder\filename.xls"
But, if Excel thinks the workbook is corrupted, Open Office seems to have good
luck in opening Excel files.
http://www.openoffice.org, a 120 meg download or a CD
Gord Dibben MS Excel MVP
>I have an extremely important xls Worksheet file, which of
>course, no back up was made. I am trying to fix it for somebody but I
[quoted text clipped - 9 lines]
>
>Thanks!