Helpful Tips to Recover Excel Files

Helpful Tips to Recover Excel Files

Have you lost your excel file(s) and looking for a suitable way to recover it? If so, then this article is for you. Anyhow, if you have never faced the deletion or corruption of an excel file, you should have knowledge of how to recover it.

Helpful Tips to Recover Excel Files

When Excel files go out of control, don’t panic. No matter how diligently you handle your excel workbooks, their corruption is a common thing. Luckily, there are few ways to get back the corrupted data.

Excel has a ‘File Recovery Mode’ that can help to recover the data when the system shuts down abruptly. But, remember this mode will not work if the file is damaged.

Now, let us look at some of the helpful tips to recover excel files.

1. Try manual feature of excel: If the automatic recovery mode fails, then give a try to manual feature. Follow the below-given steps:

  1. Click the File menu and select Open.
  2. Use ‘Look in Control’ option to find the damaged excel file.
  3. Select ‘Open and Repair’ from the ‘Open Button’ dropdown list.
  4. Then click ‘Repair’ to recover the excel file.

This method has proved to be helpful a number of times. However, if it doesn’t work for you, then give a try to the following tips too.

2. Change excel file format: If your excel file was created using an older version of MS Excel, then you might not be able to access it in the new Excel version. In such a scenario, changing the file format will solve the problem. The older format was XLS, and the new format is XLSX. Changing this format will make the file accessible. Go through the following steps to change the format.

  1. Open the file explorer.
  2. Open the folder which contains the corrupt excel file.
  3. Check the format by right-clicking on the file.
  4. If the format is XLSX, then right-click on the file again and select Rename.
  5. Change the format to XLS and press Enter. (If your current format is XLS, try changing it to XLSX.)
  6. Click ‘Yes’ to apply the changes.
  7. Now, double click on the file and try opening it.

3. Set Calculation to Manual: In MS Excel, the calculation setting is automatic by default. If you are unable to open the file, then try after setting the calculation method to manual. The following are the steps to reset the settings:

  1. Open a blank Excel worksheet.
  2. From the Tools menu, choose ‘Options’ by clicking ‘Calculation’ tab.
  3. Click ‘Manual’.
  4. Then click ‘OK’ to apply the changes.

Now, try to open the file and check if it works normally or not.

You will definitely be able to recover your corrupted excel file using the above-mentioned method. Still, if you need help with your excel files, contact a data recovery company at the earliest!