When you are working on a spreadsheet in Microsoft Excel, it can be really annoying if the file becomes damaged or corrupted. Luckily, there are things you can do to repair the data and recover the file. We take you through some of the methods. There are several options available to you: first Excel will try and repair the file itself when reopening it. If that doesn't work, it will try and extract the formulae so only the raw data is left. Failing that, you'll have to use manual options.
It's generally best to try simple options first when repairing a damaged Excel file. First, simply reopen the file to see if that makes a difference. If not, then reboot your computer and try again. If there's still no joy, open the file in Open Office, save it under another name and try another time in Excel. You can also try opening Excel in safe mode before trying the file and scanning the file for viruses to make sure there's nothing stopping it from working correctly.
Once you have exhausted the above options, you can still try some other things. First, you should try and copy the file to another hard disk so you'll have a backup copy, which is always useful. Then try and open the file in Excel. If it opens, use the Revert to Saved Document command, which will hopefully bring up the last saved version of the file. If you then save this in SYLK format and then HTML format, this should hopefully repair your data.
If you cannot open the file in Excel, then you should set the Excel recalculation to manual. Link the corrupted file to external references (by changing the .xls file anchor to .doc) and then open it in MS Word or WordPad. You should then be able to open the file in Excel viewer to recover your data. If it says that the file is corrupted, try using a macro to extract the data. You might lose your formulae but you will at least have something to work with.
If you are still unsure about repairing the corrupt file by yourself or have run out of manual options, then you can find additional help in the form of some useful third party software. Also, if you are out of other choices and you really need to get access to the file, you could use a specialized recovery services company who are experienced at recovering data. Prevent the same problem from happening again by remembering to create a backup copy of all your Excel files.
It's generally best to try simple options first when repairing a damaged Excel file. First, simply reopen the file to see if that makes a difference. If not, then reboot your computer and try again. If there's still no joy, open the file in Open Office, save it under another name and try another time in Excel. You can also try opening Excel in safe mode before trying the file and scanning the file for viruses to make sure there's nothing stopping it from working correctly.
Once you have exhausted the above options, you can still try some other things. First, you should try and copy the file to another hard disk so you'll have a backup copy, which is always useful. Then try and open the file in Excel. If it opens, use the Revert to Saved Document command, which will hopefully bring up the last saved version of the file. If you then save this in SYLK format and then HTML format, this should hopefully repair your data.
If you cannot open the file in Excel, then you should set the Excel recalculation to manual. Link the corrupted file to external references (by changing the .xls file anchor to .doc) and then open it in MS Word or WordPad. You should then be able to open the file in Excel viewer to recover your data. If it says that the file is corrupted, try using a macro to extract the data. You might lose your formulae but you will at least have something to work with.
If you are still unsure about repairing the corrupt file by yourself or have run out of manual options, then you can find additional help in the form of some useful third party software. Also, if you are out of other choices and you really need to get access to the file, you could use a specialized recovery services company who are experienced at recovering data. Prevent the same problem from happening again by remembering to create a backup copy of all your Excel files.
No comments:
Post a Comment