Organizations value Excel spreadsheets. Data tracking and financial management are common uses. Users typically have technical issues, especially when retrieving older Excel files. This article provides methods to recover saved and unsaved data and answers commonly asked issues.
Part 1: Can you restore previous versions of Excel files?
Of course! You can easily locate previous Excel files under certain circumstances. One way is to use the Microsoft Office ‘Previous Version’ tool, which can be used if the file history is enabled. Enabling the appropriate parameters is necessary to restore earlier Excel files.
Part 2: Recover previous versions of Excel files without saving
Solution 1: Using AutoRecover to restore Excel to a previous version
Excel files may be recovered without saving using AutoRecover. This function automatically saves and recovers files. Steps to activate automatic recovery:
·Step 1: Open the document and select File > Options. Select Save on the left.
·Step 2: Select ‘Minutes’ and select AutoRecover recording frequency.
·Step 3: Save adjustments with OK.
Solution 2: Restore Excel to previous version from file.TMP
.A TMP file is a temporary file that can be used to recover an earlier version of an Excel file. If you’re using Windows 10, access the temporary files folder by doing this:
·C:\Users\UserName\AppData\Local\Microsoft\Office\UnsavedFiles\
·For Windows 7 users, this is:
·C: \Users\Username\AppData\Roaming\Microsoft\Excel(Word)\
Solution 3: Restore Excel to previous version from version history under data
You can also use the worksheet properties in Excel to restore previous versions. Here’s how:
·Step 1: Open Excel and go to File > Info
·Step 2: In the Data Tab, click on the ‘Manage Workbooks’ option from the ‘Recover Unsaved Workbooks’.
·Step 3: In the following window, select the desired file and open it. Now you can recover unsaved Excel files by keeping them on your computer.
Part 3: Recovering previous versions of Excel files after saving
Solution 1: Restore Excel to a previous version from the previous version under Properties
To restore an earlier version of an Excel file after saving it. Simply access the file properties and use the previous version tool. However, this feature must enable the file history. Follow these steps:
·Step 1: Right click on the Excel file and select ‘Properties’ from the menu.
·Step 2: In the ‘Properties’ window, go to the ‘Previous Version’ tab, select the version you want to restore and click ‘Restore’.
Solution 2: Restore Excel to previous version using Manage Workbook
Another powerful way to restore previous versions of Excel files in Windows 10 using the Workbook features, follow these steps:
·Step 1: Open the latest version of the file and go to File > Information. In the Data tab, click on the Manage Workbook option.
·Step 2: In the ‘Manage Workbook’ window, find the desired version of the file and click ‘Restore’.
Bonus Tip: Recover previous versions of Excel files with Data Recovery Tool
In unfortunate situations such as mistaken deletion or mysterious disappearance of Excel files, a reliable excel recovery software can save lives. WinfrGUI is a graphical version of Windows File Recovery developed by Microsoft Corporation, which makes the recovery process easier without requiring complicated commands. Here are the features of Winfr GUI:
·Easy recovery of deleted or missing files such as Excel, Word, PowerPoint, etc.
·Supports file recovery from Windows, USB flash drive, SD card, external hard drive and so on.
·Inadvertent deletion repairs, RAW file system formatting errors, and damage.
·Supports more than 1000 types of data for recovering photos, videos, audio and documents.
·Quick scanning and strong security measures to protect data during recovery.
·To recover lost Excel files using WinfrGUI, follow these steps:
·Select Location: Select a drive with missing or removed Excel files in WinfrGUI. Select the file type to be scanned in the following window.
·Scan for deleted Excel files: Allows WinfrGUI to scan the drive for recoverable files.
·View Sample and Recover Deleted Excel Files: Select the Excel file you want to recover from the file received after scanning. Click ‘Recover’ to restore the deleted excel file.
With WinfrGUI, you can apologize for the problem of missing Excel files and experience the convenience of smooth recovery at your fingertips. It can be used to recover deleted Word documents in the same way.