Repair to a corrupt Excel 2007 spreadsheet.

simonjcraig · 2013-09-14T21:04:46Z

ProblemTwo days ago i was working on an work excel spreadsheet master copy located on a verbatim 32gb thumb drive and at the end of the day saved it on the thumb drive as usual. I then copied the .xlsx file and overwrote the two other copies that i keep, one locally on my PC, the other on the small office network.The next day i tried opening the file on the thumb drive in windows excel 2007 and it stated there was an error, i.e. unreadable content. I selected the option to recover the data, then got a box saying that Excel was able to open the file by repairing or removing the unreadable content, plus its said ‘Replaced Part /xl/worksheets/sheet1.xml part with XML error. Whitespace expected. Line 2, column 81501.’ On closing this to view the spreadsheet, the whole sheet was actually blank however.Its a key document i use at work, with over 1.5 yr of data on it, so im keen to retrieve it.I’ve tried the following1) Opening a new blank spreadsheet and selecting the open and repair option. Same result2) Tried opening in office 2000, text data visible, but not decoded3) Changed file extension to .doc but would not open in word4) Changed the file extension to .txt and opened in notepad. Was able to see text data, but unreadable.5) Opened in Open Office and it did open successfully the first 66 ,lines of the 200 line or so document6)3rd party tools.a. Excel repair toolbox – Same result as using Open Office – 1st 66 lines retrieved onlyb. Recovery for Excel – dittoc. NB I tried about 8 programs in total, but most would not retrieve anything7) I opened computer in safe mode and tried to open. No difference as when not in safe mode8) A friend renamed the file as .zip and used winrar to open the file in .xml, but unable to then do anything with it.9) Tried opening on a Mac Book. The preview showed the spreadsheet in thumbnail size, but it would not opened teh actual document.I spent 10 hours trying everthing i could yesterday and trawled the internet for solutions, all to no avail. Any suggestions as to what software i might be able to use would be gratefully received.Simon