Excel Found unreadable Content in...

[prasaddn]

Hi,


Whenever I open one particular file it pops up stating excel found unreadable content in myfile and prompts me yes for recover..


when I press yes, it shows up another pop .. Removed Records: Sorting from /xl/worksheets/sheet5.xml part


and the log show following information..

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

- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error055760_01.xml</logFileName>

<summary>Errors were detected in file 'C:UsersPrasad_dnDesktopBCBS Demo Data.xlsm'</summary>

- <removedRecords summary="Following is a list of removed records:">

<removedRecord>Removed Records: Sorting from /xl/worksheets/sheet5.xml part</removedRecord>

</removedRecords>

</recoveryLog>


any help please....................


Regards,

Prasad DN

PS: The file has vba macros and sorting of records

 

[SirJB7]

Hi, prassadn!

Tried opening the file, saving as in another location, adding manually records excluded, saving, and re-opening it?

Besides, does it give you the chance to not recover? If so, after saving as in another location, do you get all the records?

A third approach, can you open it normally disabling macros? Then save as, reopen the original enabling, export/copy modules, open the saved one, import/copy modules.

Regards!

PS: run a chkdsk /F on drive?