How to repair corrupt Excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xing - 12 Jan 2007 01:51 GMT

When the Excel file is opened via Windows Explorer,
it has crazy format that I cannot understand,
and I cannot access the data I want to access.
How can the above be corrected

--
Xin

Posted from - http://www.officehelp.i

Reply to this Message

Gail - 12 Jan 2007 16:06 GMT

It is possible that someone opened the file in Word and allowed it to be
saved through that application. Save a copy of the file and try opening it
in word to see if the data is legible. If so, you will need to recreate
your file

> When the Excel file is opened via Windows Explorer,
> it has crazy format that I cannot understand,
> and I cannot access the data I want to access.
> How can the above be corrected?

Reply to this Message

Bill Sharpe - 13 Jan 2007 22:05 GMT

> When the Excel file is opened via Windows Explorer,
> it has crazy format that I cannot understand,
> and I cannot access the data I want to access.
> How can the above be corrected?

Can you open the file from within Excel? If so, try saving it with
another name.

Bill

Reply to this Message

Joseph Mc Daid - 14 Jan 2007 07:06 GMT

Xing,

A trick I often use is to open the effected Excel file with Calc (a
free spreadsheet program that can open Excel files -
http://www.openoffice.org/) and then resave it using Calc. Once
resaved, the resultant file can normally be opened in Excel without any
hassle.

Remember to make a backup of the Excel file or resave the file to a
different location!

HTH,

Joseph Mc Daid
http://www.bpmhome.com

> When the Excel file is opened via Windows Explorer,
> it has crazy format that I cannot understand,
[quoted text clipped - 8 lines]
>
> Posted from - http://www.officehelp.in

Reply to this Message