Osman Goni Ridwan
We work on Excel files regularly and often it gets corrupted. It may happen for reason but most of the time you may not know the reason behind the corrupted Excel file. This article will help you on how to recover corrupted Excel file in 8 possible ways. If you face this problem then you can try these methods one by one.
8 Easy Ways to Recover Corrupted Excel File
Assuming that you have a file that has been corrupted after saving. And it was very important so you’re desperate to recover it anyhow.
I’ve tried the following possible ways to recover a corrupted Excel file and I’m sharing these methods with you. All of them may not work for you but you should try all of these ones by one to recover your file.
1. Using the Open and Repair Tool of Microsoft Excel
When you face a corrupted excel file at the time of opening, it will automatically ask you to attempt to repair the file. If it doesn’t start then you have to do it manually. The steps are shown below:
STEPS:Â
- First, open the Microsoft Excel software and go to the File tab > Open.
- Now set the file destination in the File Name box. Before it, you have to select All Files from the right corner drop-down menu. Then open the drop-down menu of the Open option. And select Open and Repair.Â
- Then a box will appear. Press the Repair button.
- Then another box may appear. Must select Yes on the box.
- There you may see the Excel file opens in normal mode.
2. Use External References to Link to the Corrupted Workbook
If you can’t open the corrupted file, you may try to retrieve the data. There is a way to retrieve data from the corrupted workbook by using external references.
STEPS:
- First, go to File > Open.
- Then go to the corrupted file destination and copy the file name by using Ctrl + C. Â Here you have to select All Files in the right bottom corner. Else the corrupted file may not be shown.
- Now go to the blank workbook. And the cell A1, write =’File Name’!A1 then press Enter.
- A dialog box will appear, select the sheet that you want to retrieve and press OK.
- Here you will see a 0 in the cell. Now copy the cell by Ctrl + C.
- Then, select a range of cells that will cover the data of the sheet and press Ctrl + V to paste. Now again copy all cells and paste only values.
- Here you will have lots of 0. Actually, they should be blank cells. To replace them, go to Find & Select > Replace.
- Then, input 0 in the ‘Find What’ box, and leave the Replace with box empty. And press the Replace All button.
- After that you will see only the wanted values. And all zeros are replaced with empty cells.
3. Restore from File Recovery
This option will help you if you already have a backup. As, by default, it makes a backup after every 10 minutes. You should also recheck it by the following steps:
STEPS:
- Open an Excel File and go to File > Options
- A new window named Excel Options will appear. Now press on the Save options. And select all the checkboxes under the Save Auto Recover information dialog. Only uncheck the box named Disable Autorecover option. Also, check the location where the file will save.
- Now after every 10 minutes, a backup file will be saved in that folder. If the file gets corrupted while running, you can recover it from that folder.
Read More: How to Backup Excel Files to a Flash Drive (4 Useful Methods)
4. Set the Calculation Option in Excel to Manual
Sometimes, while dealing with larger datasets and complex calculations the file may crash while opening and get corrupted. In these cases, you can use the following method.
STEPS:
- Open a new Excel file. And go to File > Options > Formulas. Under The Calculations Options, select the Manual option. And press OK.Â
- Â You can select the Manual options from the top ribbon. Go to Formulas and select Calculations Options, there will open a drop-down menu. Select Manual option from here.
- Â Then go to File > Open and locate the destination of the corrupted file and double click on the file to open it.
5. Recover Corrupted Excel by Saving as Another Format
You can try to recover corrupted Excel by saving it in another format and opening it again in Microsoft Excel.
STEPS:
- Try to open the corrupted file and go to File > Save as and select any possible formats like a Web page and press Save.
- Now open a new Excel file and go to File > Open and locate the saved file and double click to open.
- If it doesn’t open normally then go to File > Save as and select the Save as Type as Excel format .xls or .xlsx
Read More: How to Undo Changes in Excel after Save and Close (2 Easy Methods)
6. Move the File to Another Folder
Sometimes the operating system can’t access the file because of network and servers error. You may think that the file is corrupted. But actually, it is not. So you should move the file to another folder and retry opening it. It may work sometimes.
7. Try to Open the Corrupted Excel File in NotePad or Word
If all methods fail, and you can’t open the corrupted file anymore, but the data is very important and you have to recover the data, then you can try this method.
STEPS:
- Right-click on the mouse on the file and select open with.Â
- Select the option NotePad or Word.Â
- Now, the excel file may open in word format. In this method, you may recover the data only. But you will lose all the formulas and formats.
- You may try any Word to Excel Converter Tool to recover the Excel file.
8. Revert Workbook to the Last Saved Version
If you think that the file has become corrupted while working on it you should follow this method to recover the corrupted Excel file by reverting them to the last saved version.
STEPS:
- Go to File > OpenÂ
- Locate the file where it is saved and double click on the name to open while it is already opened,
- Click Yes to re-open the file. This method will save your file from being fully corrupted but you may lose the latest edits.
Read More: [Fixed:] Unsaved Excel File Not in Recovery
Recover Excel Files from USB/Flash Drive
Sometimes, while sharing an Excel file through a USB / Flash drive, it gets corrupted. There can be various reasons behind it. I will show you the solutions to how you can recover Excel files from the USB / flash drive.
1. Restoring the Previous Versions
It is the simplest option to repair the corrupted Excel file. But a fact you should know is that to work with this method, you must have enabled the system’s Windows backup option before. If it is already enabled then you can follow these steps:
STEPS
- Locate the corrupted Excel file and Right Click on this file
- And select the Restore previous versions option
- There you will find a list of available versions then select one of them. The file may get recovered from corrupted.
Read More: How to Recover Previous Version of Excel File (4 Easy Ways)
2. Using CMD to Recover Corrupted Excel Files
With this method, you will repair the USB flash drive. So then you can open the Excel file.
STEPS:Â
- At first, go to Start Menu and type CMD, and hit Enter
- Then a Command Prompt window will appear, Now Type “ attrib -h -r -s /s /d (Flash Drive Letter):\*.* “ and press Enter.Â
- Now, the repairing process of the flash drive will start. Wait till the process is over. Then try opening the files.
Read More: How to Recover Overwritten Excel File with No Previous Version
Conclusion
All these methods are to help with the question of how to recover corrupted Excel file. You can try these methods one by one as there can be many reasons to corrupt an Excel file so the solution will also be different. To recover a corrupted Excel file, you may try all these methods one by one. I hope you found this article helpful. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
