Whitespace expected

Question

Hi..

One of my excel file has been corrupted, when I am opening it showing an error "excel found unreadable content in .xlsx 2007". So you want to recover the content of the workbook? If you trust the source of the workbook. Click Yes."

When I click on yes, it is showing the error  "Excel was unable to recover the file by repairing or removing the unreadable content.

Replaced Part: /xl/worksheets/sheet1.xml part with XML error.  Whitespace expected. Line 2, column 4163257."

Here is the .xml logs. "

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error048720_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\amar\Desktop\FAILED.xlsx'</summary>-<removedParts summary="Following is a list of removed parts:"><removedPart>Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Whitespace expected. Line 2, column 4163257.</removedPart></removedParts></recoveryLog>"

Please help me to recover this file.

Thanks & Regards

Amarjit Kumar

Answer 1

Hi Tyrell,

I have tried it but the issue is still same.

Thanks

Answer 2

Try Kai7's steps from:

http://answers.microsoft.com/en-us/office/forum/office_2007-excel/excel-found-unreadable-content-in-bookname-without/957efce2-fdc8-4d47-94f6-dab6670604b0