Tanjim Reza
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.
- 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.
- At this time, find your AutoRecover file location.
- Now, select the location and Copy it.
- At this time, go to the Folder Toolbar of your PC. Paste the copied location here.
- 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.
Thus, from all the previous versions available here, you can select and open any version of your file by double-clicking on the file.
Read More: How to Undo Changes in Excel after Save and Close (2 Easy Methods)
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.
- Choose the Manage Workbook option from the Info window.
- 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.
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.
Read More: [Fixed:] Unsaved Excel File Not in Recovery
Similar Readings
- Recover Overwritten Excel File with No Previous Version
- How to Recover Excel File Password (2 Easy Ways)
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.
Read More: How to Auto Backup Excel File (2 Easy Methods)
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.
- 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.
Read More: How to Backup Excel Files to a Flash Drive (4 Useful Methods)
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.
Subsequently, you will see the deleted file is restored again in your folder just like this.👇
Read More: How to Recover Permanently Deleted Excel Files Online
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.
