While working with Microsoft Excel, there are a variety of unanticipated events that might result in our data being completely lost, such as a system crash, a computer being stolen, a hard drive failing, or even a natural disaster. Backing up files and folders is the greatest approach to keeping data secure. Whenever we make a file backup, you’re storing duplicates of an essential system. In this article, we will demonstrate different effective methods to find Excel backup files.
How to Find Backup Files in Excel: 5 Easy Methods
The primary goal of data backup is to protect essential information in the case of a system crash or hard disk malfunction. If the initial backups result in data damage or hard disk failure, further data backups should be made.
Let’s pretend I have created a fresh Excel worksheet (Book1). In Sheet1 of the spreadsheet, we stored some information about data of some students’ marks. Now, assume that our computer is turned off for some reason or we shut down the computer without saving the Excel file. But we need that mark record. So, we need to find the Excel backup Files. Let’s see the approach to do this.
1. Get Excel Backup Files from ‘Recover Unsaved Workbook’ Feature
To find the Excel backup files to recover an unsaved Excel file, we need to follow some procedures. Let’s look at the procedures.
STEPS:
- First, make a new workbook in Excel.
- Secondly, navigate to the File tab.
- Thirdly, select Open from the drop-down menu.
- Then, click on the Recent Workbook option at the top left.
- Scroll to the bottom of the page, and click the Recover Unsaved Workbook button.
- This will appear in a Document Recovery window.
- As a result, Excel will display the files that have not been saved.
- And, that’s it! By just following the above steps, we will be able to find the backup files in Excel.
2. Use ‘Manage Workbook’ Option to Find Excel Backup Files
Workbook Manager creates a database of all open Excel documents so we may simply browse through them. We can find Excel backup files from the Manage Workbook option in Excel. For this let’s see the steps down.
STEPS:
- Similar to before, first, open Excel.
- Then, go to the File tab from the ribbon.
- Next, click on the Info option.
- Then, click OK on the Manage Workbook drop-down menu bar.
- And, select Recover Unsaved Workbooks.
- Likewise the previous method in the Document Recovery window, the file will appear.
- That’s all! You will be able to find the backup Excel files by following the steps.
3. Excel ‘Version History’ Feature to Find Backup Files
Excel Version History keeps track of the modifications made to our documents over the course of their existence. Version History, in particular, allows us to access older copies of our files and displays the amount of each edition, the volume of each version, and also who and when each edition was made. We can maintain track of all the many versions of workbooks you’ve stored over time with Excel Version History. Let’s see how we can find Excel backup files with this.
STEPS:
- In the first place, as similar as before, open the Excel document.
- Next, go to the File tab.
- Then, go to the Info option.
- Scroll down a bit, you will see Version History.
- Now, click on that Version History.
- This will navigate the Version History window.
- And, finally, by just following the above steps, you will detect your backup files in Excel from Version History.
Read more: How to Recover Previous Version of Excel File
4. Search for Backup Files in Excel File History
We can also obtain the Excel backup files from our File History. Let’s see how we can use our File History to obtain Excel backup files.
STEPS:
- To begin with, go to your window search bar.
- Then, type restore file.
- Press Enter to proceed.
- After that, you will see Restore your files with the File History option.
- Click on that and you will be able to perceive the backup Excel files.
- In the end, we can discover the backup files in Excel by simply following the procedures above.
5. Find Excel Backup Files on OneDrive
If you have your personal OneDrive logged in on your Excel file. You will be able to discover the Excel backup files from there. Let’s see where we can locate the backup files on OneDrive.
STEPS:
- To begin, open Excel and create a new worksheet.
- The second step is to go to the File tab.
- After that, from the drop-down option, choose Open.
- Now, from the Shared with Me option, you will see OneDriveB Personal.
- Click on OneDrive.
- This will take you to the file location where your backup file is located.
- Finally, we can discover the backup files in Excel by simply following the procedures above.
Download Practice Workbook
You can download the workbook and practice with them.
Conclusion
The above steps will assist you in finding Excel Backup files. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section.
Related Articles
- How to Auto Backup Excel File
- How to Backup Excel Files to a Flash Drive
- How to Recover Corrupted Excel File
- How to Recover Corrupted Excel Files from USB
- How to Recover Excel File after Crash
- How to Recover Permanently Deleted Excel Files Online
- How to Undo Changes in Excel after Save and Close
- [Fixed:] Unsaved Excel File Not in Recovery
- How to Recover Overwritten Excel File with No Previous Version
<< Go Back to Recover Excel File | Excel Files | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
