How to Recover a Deleted Excel File (5 Effective Ways)

It is pretty normal to lose an Excel file. You can lose an Excel file by deleting mistakenly. You can lose your Excel file by sudden shutdown or restart of your device. Besides, you can also lose your actual Excel file by putting the wrong inputs. At these times, you don’t need to panic anymore. There are many ways to recover a deleted or unsaved Excel file. In this article, I will show you 5 effective ways to recover a deleted Excel file.


Practice Workbook

You can practice with our workbook by downloading it from here.


5 Effective Ways to Recover a Deleted Excel File

1. Recover a Deleted or Unsaved Workbook from the AutoRecover File Location

Say, you have forgotten to save your changes to your Excel file. Or, you have done unwanted changes mistakenly. Now, if you want to recover your actual Excel file, then follow the steps below:

Steps:

  • First, click on the File tab from the ribbon.

How to Recover a Deleted Excel File

  • Now, click on Options from the expanded File tab.

How to Recover a Deleted Excel File

  • Subsequently, the Excel Options window will open. Click on the Save option from the left side list.

How to Recover a Deleted Excel File

  • At this time, find your AutoRecover file location.

How to Recover a Deleted Excel File

  • Now, select the location and Copy it.

  • At this time, go to the Folder Toolbar of your PC. Paste the copied location here.

How to Recover a Deleted Excel File

  • Subsequently, press Enter. You will see that you are taken to the AutoRecovery file directory. Here, you will find all the previous and unsaved Excel files.

How to Recover a Deleted Excel File

Thus, from all the previous versions available here, you can select and open any version of your file by double-clicking on the file.


2. Recover Unsaved Excel Files

Imagine, you were working with an Excel file and suddenly it crashed and you realized that you haven’t saved the last changes. In this situation, you can recover the Excel file using the Manage Workbook option. Follow the steps below to execute the approach:

Steps:

  • First, click on the File tab from the ribbon.

  • Choose the Info option from the expanded File tab.

How to Recover a Deleted Excel File

  • Choose the Manage Workbook option from the Info window.

How to Recover a Deleted Excel File

  • Now, a new file window will appear. Here, you will see all the versions of your Excel file. Choose the version you want and click on the Open button.

How to Recover a Deleted Excel File

Remark:

We have no unsaved file so far, so nothing appears here from our side. But you will definitely find the unsaved files in this folder.

Thus, the version will be recovered.


3. Use AutoRecover and AutoSave Options

AutoRecover and AutoSave options can also be used to recover Excel files. Use the following steps to do so:

Steps:

  • First, click on the File tab from the ribbon.

  • Now, click on Options from the expanded File tab.

  • Subsequently, the Excel Options window will open. Click on the Save option from the left side list.

  • Now, tick on the Save AutoRecover information every option and choose the desired minutes that you want to save after. Subsequently, choose the AutoRecover file location in the marked box. Click on the OK button.

How to Recover a Deleted Excel File


4. Use OneDrive to Recover Excel File

If you use Microsoft 365 apps and if you have a Microsoft account, you can also sync all files to your OneDrive cloud and restore your deleted or unsaved files from the cloud. Follow the steps below:

Steps:

  • First, open a Microsoft account. Then, open your Excel file and turn on the AutoSave button.

How to Recover a Deleted Excel File

  • It will pop up a window where it will ask you to sign in with your OneDrive account. Now, sign in with your account. Thus, your files will be automatically uploaded to the OneDrive cloud at a definite time interval.

  • You can also upload your Excel files directly from your OneDrive account. Sign in to your OneDrive account >> Click on Upload>> Click on Files >> Browse the file that you want >> Click on Open.

How to Recover a Deleted Excel FileHow to Recover a Deleted Excel File


5. Recover a Deleted Excel File from the Recycle Bin

If you delete an excel file by mistake, the easiest approach is to recover it from your Recycle Bin. Use the following steps to do so:

 Steps:

  • Go to your desktop and you will see a folder named Recycle Bin. Double-click on the folder.

  • At this time, you will see the deleted file in your Recycle Bin folder. Right-click on the deleted file and click on Restore from the context menu.

How to Recover a Deleted Excel File

Subsequently, you will see the deleted file is restored again in your folder just like this.👇

How to Recover a Deleted Excel File


Conclusion

There are several ways to recover a deleted Excel file. Here, I have mentioned 5 effective ways to recover a deleted Excel file. Follow any of these ways to recover your file matching your condition. I hope, you find this information informative and helpful. If you have any further queries or recommendations, please feel free to contact me. And, visit exceldemy.com for many more articles like this.

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo