Before leaving work yesterday, when the Excel 2007 format (. xlsx) document that was painstakingly edited for one day was turned off, a shadow was turned on the document and the following error occurred:
Select Yes to recover, and the following error message appears, and all text content is lost.
Then try some methods, did not succeed, search the internet for similar cases, which may be really a bug in Excel 2007, and all articles do not give a solution, it seems that the hope of the recovery of the file is gone.
Tell me what I have done:
1 confirms that you are using the. xlsx document format, the results from the web search is the Microsoft's proprietary format
2 The Repair method provided by Excel is only the "content recovery" of the program itself.
3 from the Internet to find a document, introduced the. xlsx document format, know it is actually a zip compressed XML file collection
4 after decompression to view the contents of Xl/sharedstrings.xml file, found that the content of their own writing is still in.
5 directly with the browser to open xl/sharedstrings.xml found such a bad hint:
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Office/excel/