1. Home
  2. Office

How to recover corrupted file in Excel?


0

how to recover corrupted file in excel?

Computers, which provide convenience in all areas of our lives, and the various programs in them have now become indispensable for us. The program that helps us with the spreadsheet is excel. Excel provides us both time saving and convenience in drawing graphs about the data, preparing reports and summaries easily and quickly, accessing, sorting and querying the desired data. However, in some cases, we cannot safely store files from mis-saving or virus infection. In this article, we will give you information about Excel file recovery.
Excel file recovery is usually ExcelWhile you are editing the worksheet, the file may be accidentally corrupted before you save the changes. The steps you need to do are as follows:

  • Click Open from the File menu and select the name of the file you are editing.
  • Then after selecting Open and Repair the file will automatically recover and repair itself.

In addition to this, there is another method that will help you in Excel file recovery. It can also secure your file by creating an automatic recovery file at regular intervals, and it will help you easily access it when it gets corrupted or accidentally deleted.

First select File in Excel and then click Options .

After selecting the Save category, check the “ Save auto-recovery information”  box and enter the number of minutes depending on the importance of your document and your request. The number of minutes we enter is 5.

Then you enter the location where you want to save the recovery file in the Auto recovery file location  box . There is just one more thing you should pay attention to.

You should make sure that the Disable auto-recovery only for this workbook  checkbox is unchecked. Because if it is checked, it is not possible to save your work. These are the things you need to do.

 

Write a Comment