English
Français
Español
Deutsch
Italiano
日本語
简体中文
繁體中文Microsoft Excel is a necessary program with which you can create detailed spreadsheets and colorful charts. Excel is as important as Word and Outlook. Nothing is more annoying than realizing you’ve forgotten to save an excel file which is really important. Unpredictable power off or software crash are often the culprits that cause. However, if an XLS file is damaged or corrupted, all of the important data could be lost. Fortunately, Microsoft Excel has an Autosave feature that can save it automatically every few minutes. If you cannot open an XLS file or it closes immediately after opening, you can use Excel’s tools to try to recover it and save crucial data.
Method A:
- Start Excel. Click the “File” menu or the “Office” button and select “Open.”
- Find the file that is not working correctly in the “Open” window. Click on it once to select it. Click the arrow next to “Open” and select “Open and Repair.”
- Click “Repair.” This option will attempt to repair and open the complete XLS file as close to the original format as possible.
- Close the Excel window and reopen it if the repair did not recover the XLS file. Go back to the “Open” window and click on the file. Click the drop-down arrow to the right of “Open” and click “Open and Repair” once more. This time, click the “Extract Data” button.
- Select “Recover Formulas” to recover as much of the file as possible. If this does not work, go back and choose “Convert to Values.” If the last option is the only one that recovers data from the file, you may have to format the data and insert formulas again.
Method B:
If Method A cannot help you to recover it, you can try a professional data recovery program. I recommend Wiserecovery to you. It is a top ranking program which has great reviews.
- Download WiseRecovery Software, install it and launch it. Click the “Start Scan” button on the main window of WiseRecovery.
- You can see the list of all volumes found on your computer, select the exact drive and click the “Next” button to start scanning. If you can’t see the drive, please make sure your external drives are connected, and click ‘Refresh’ button.
- It will take about 2-10 minutes to scan, it depends on your disk size and files amount on the disk. After scanning is finished, you can preview text document and picture files.
- Select the files or folders that you want to recover and press the “Recover” button, on the popup window, please select target directory to save the recovered files. WiseRecovery will recover files instantly. Now you can click ‘open the destination directory’ button to see the recovered files!
- Note: Please don’t recover the file to the disk you are recovering files from!
