When we handle a vast dataset in Excel, sometimes it becomes required for us to get the earlier version of our spreadsheet. Besides it, sometimes we accidentally close our file without saving it. Excel has amazing features to get back those types of files. If you are also interested to know how to recover the previous version of the Excel file, then download the practice workbook and follow us. Show
Download Practice WorkbookDownload this practice workbook for practice while you are reading this article. 4 Easy Methods to Recover Previous Version of Excel FileTo demonstrate the approaches of recover the previous version of an Excel file, we consider a dataset of 10 text strings. So, our data set is in the range of cells B5:B14. The name of our worksheet is Recover Previous Version of Excel File.xlsx. We will try to get the earlier version of this file. 1. Recovering from Version HistoryWe can get the previous version of our spreadsheet from Excel’s built-in feature called Version History. For recovering a file by this option, you have to always keep your Autosave feature On. The steps of this process are given below: 📌 Steps:
Thus, we can say that our working method worked successfully and we are able to recover the previous version of our Excel file. Read More: How to Recover Overwritten Excel File with No Previous Version 2. Retrieve Previous Version from Manage Workbook OptionAn Excel built-in feature called Manage Workbook can also help us to retrieve the previous version of our Excel file. Using this option we can also open the unsaved file and save it. The procedure of this process is explained below: 📌 Steps:
So, we can say that our process worked successfully and we are able to recover the previous version of the Excel file. Read More:How to Undo Changes in Excel after Save and Close (2 Easy Methods) Similar Readings
3. Using File Properties to Get FileThe previous version of an Excel file can also restore from the Properties option of your device. For that, you must have to keep Turn On the File History option on your device. Otherwise, you cannot able to use this method. Follow these steps to recover your previous version of the Excel file: 📌 Steps:
In the end, we can say following the steps properly you can recover the previous version of your Excel file. Read More: How to Find Backup Files in Excel (5 Easy Methods) 4. Recover Unsaved File from Document RecoverySometimes our Excel file accidentally closes without final saving due to power failure or hardware failure. In this case, Excel automatically provides you the option once to recover your file data. If you don’t recover your file at that time, it will get lost forever from your device’s memory. It is a very easy process. The steps of this method are shown below as follows: 📌 Steps:
At last, we can say that through this process you can recover the previous version of an unsaved file. Read More: [Fixed:] Unsaved Excel File Not in Recovery ConclusionThat’s the end of this article. I hope that this article will be helpful for you and you will be able to recover the previous version of the Excel file. If you have any further queries or recommendations, please share them with us in the comments section below. Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing! Related Articles
Can you restore previous versions in Excel?If the file has previous versions, you'll see a button called Version History. Select it to open the pane. Select a version to view it. Once you've chosen the one to restore, select Restore at the top to restore it.
How do you recover an Excel file that was accidentally overwritten?How to Recover Overwritten Excel File with Built-in Tool in Excel. Open Excel, and click "File" > "Info" > "Manage Workbook". Click "Recover Unsaved Workbooks" from the drop-down menu.. Select the unsaved file and click the "Open" button.. Then, choose "Save As" in the bar at the top of the file to recover it.. How can I recover a file I accidentally saved over?Restore Previous Versions (PC) – In Windows, if you right-click on a file, and go to “Properties,” you will see an option titled “Previous Versions.” This option can help you revert to a version of your file before the overwrite occurred, allowing you to get your data back.
|