I had an Excel file go bad on me today. I spent a few hours getting it all wired up, only to to open it up later and be faced with the error;
Very frustrating!
I did learn a bit about accessing/fixing corrupt Excel files though. Here are some tips I found to deal with a corrupt Excel file.
I. Excel has a built-in "fix" feature. When opening a file in Excel, you can ask Excel to try repairing the the file by selecting Open and Repair in the File|Open dialog box.
That did not work for me...
II. If you just need to view the data in the Excel file, you can download the free Microsoft Excel File Viewer to try viewing the data in your corrupt file.
That did not work for me either...
III. Try opening the file in Microsoft Word. For me, the file opened in Word, but it came up as gibberish.
Still no luck, I need to keep trying...
IV. Try opening the file in Google Docs. Google docs is a web based set of Office-like applications that can read and write Microsoft Office formatted files.
Nope, Google Docs could not open my file...
V. In a new Excel worksheet, you can try linking to the corrupt workbook and pull the data out.
- Start Excel.
- From the File menu, Select Open. Browse to the folder with the corrupt file, then click Cancel.
- Select File | New.
- In Cell A1, enter =FileName!A1. Where FileName is the name of your corrupt file. If the "Select Sheet" dialog box appears, select the appropriate worksheet and click OK.
- Copy Cell A1 to the cells with the data you want to pull from the corrupt workbook.
This worked for me, woo-hoo!
If you ever encounter a corrupt Excel file, I hope one of these tips works for you. I'd highly recommend giving these tips a try before buying one of the many Excel "repair" applications that claim to fix corrupt Excel files.
2 comments:
There is fine tool,which able,will help you-fix Excel file,
will analyze your damaged document and show you its content in a preview window, will allow you to fix files Excel and see, which elements will be recovered and which are damaged too badly,the last ones are impossible to recover and will be lost,whether you'd like to recover all of your damaged documents manually and spend many days for this purpose, or it will be better to use an Excel files fix, it is a cheap solution for Microsoft Excel fix, that can be also called as Microsoft Excel fixer.
Thanks :D It helped me
Used Tip about Google Docs
Post a Comment