The most current version of Microsoft Office is Office 2019. There is a perpetual version (desktop or standalone version) that is a one-time purchase. Office 2019 comes in three editions (as noted above), 2019 Home and Student for Pc/Mac, 2019 Home and Business for Pc/Mac and Microsoft Office 2019 Professional. How can I recover a previous version of an excel spreadsheet where changes were saved after an accidental deletion of important info?I was working on an excel spreadsheet yesterday and had to leave my computer to run an errand and when I returned to my computer, I just saved all the documents and spreadsheets I had been working on earlier in.
Quick navigation for solutions to recover previous version of Excelwhether the Excel file is saved or not:
Workable Solutions | Step-by-step Troubleshooting |
---|---|
Fix 1. Restore from Previous Version | To recover saved over Excel file, right-click on the saved Excel > 'Properties' > 'Previous Versions'..Full steps |
Fix 2. Recover previous saved Excel | To recover overwritten Excel file, open Excel > 'File' > 'Info' > 'Manage Documents' > 'When I closed'..Full steps |
Fix 3. Recover from AutoRecover | Recover unsaved Excel file, open Excel > 'File' > 'Info' > 'Manage Workbook' > 'Recover Unsaved..'..Full steps |
Fix 4. Recover from .TMP File | Restore Excel previous version, Find Excel temp file with .TMP extension > Copy and change extension..Full steps |
Q: How to recover a previous version of an Excel spreadsheet after saving it?
'Is it possible to recover a saved-over Excel to a previous version? I got a very important two-sheet Excel file, but it was saved by mistake, and there was only one spreadsheet left with much useful data loss. I don't know how it happened without me knowing it. I need the lost data back. So, I'm hoping someone will be able to help and tell me if I can recover a previous version of this spreadsheet before the deletion occurred? If so, how do I do this?'
Recovering an Excel file that was saved over is a long-standing hot issue for many users. How you can restore earlier Excel depends on whether you've saved it or not. If the Excel file is still open, you can directly use Ctrl + Z or the Undo option to revert the Excel file to an earlier state.
However, if the edited Excel is saved and closed, recovery is not so easy. In the following content, we will discuss how to recover previous version of Excel file 2016, 2013, 2010, and 2007 in two cases. One is restoring older Excel version if you've saved the file, the other is recovering the previous version of Excel if you haven't saved it. Besides, in the end, we highly recommend you try EaseUS Data Recovery Wizard to recover lost saved Excel file without effort.
How to Recover Previous Version of Excel File After Saving
Two ways are available to help you restore previous version of Excel file by using Windows backup feature and Excel's Manage Wordbook feature.
1. Recover Earlier Version of Excel File from Previous Versions
Windows can automatically save old versions of your data files when you have enabled the File History and system backup and restore.
Step 1. Open File Explorer and locate the Excel/Word file.
Step 2. Right-click on the Excel file and select 'Properties'.
Step 3. Click the 'Previous Versions' tab and select the version you would like to get back and then hit 'Restore'.
2. Restore Excel File to Previous Version with Excel's Built-in Tool
Step 1. Open the file you are working on;
Step 2. Go to 'File' and click 'Info'. Under 'Manage Documents', click the file labeled 'When I closed without saving'.
Step 3. Click 'Restore' in the bar at the top of the file to overwrite any previously saved versions.
How to Restore Previous Version of Excel File Not Saved
If you haven't saved the file, try below two approaches to get an Excel file earlier version back.
1. Recover Unsaved Excel File from AutoRecover
If the AutoRecover option is turned on, Windows can automatically save versions of your file while you're working on it. You can recover previous version of Excel that is not saved by following steps below. Ubuntu small iso.
Step 1. Click 'File' > 'Info' > 'Manage Workbook' > 'Recover Unsaved Workbooks' .
Step 2. Select the file and click 'Open'. Type tool meaning.
Step 3. In the bar at the top of the file, click 'Save As' to save the file.
2. Recover Old Version of Excel File from .TMP file
Microsoft Office has this feature that it would automatically save temp files for the file that you are editing. So you can try to find the .TMP file to get an earlier version of Excel or Word file back:
Step 1. Follow the temp file folder location on your PC and find the Excel/Word temp files with .TMP extension.
- For Windows 7 users: C:UsersUserNameAppDataRoamingMicrosoftExcel
- For Windows 8/10 users: C:UsersUserNameAppDataLocalMicrosoftOfficeUnsavedFiles
Step 2. Locate and find the temporary excel or word files begin with '$' or '~' and end with “.TMP”, select the right version of Excel/Word temp file by date, then copy and save to another safe spot by changing the extension from .TMP to .XLS/.XLSX or .DOC/.DOCX.
Conclusion: If your Excel file got overwritten accidentally with data loss, you could use the four methods in total to recover previous version of the Excel file. In addition to Excel getting saved over, users also have trouble with Excel loss caused by mistaken deletion, storage device formatting, OS crash, virus attack, recycle bin emptying, and so on. Under these circumstances, the above approaches are not useful any longer. Then, how to recover deleted Excel document? Calm down and use the data recovery software demonstrated below to get back lost Excel easily.
How to Retrieve Deleted/Lost Excel File with Data Recovery Software
If you've already deleted the earlier version of Excel file, or if the saved Excel gets lost due to careless deletion, hard drive formatting, and other reasons, you can use EaseUS Data Recovery to help you restore the deleted Excel from your PC or other storage devices within three steps. It even enables you to recover files from emptied recycle bin.
What Version Is My Excel
Now, install this program and follow to see how to get your lost Excel/Word file back effortlessly.
Step 1. Launch EaseUS Office file recovery software on your computer. Choose the exact location where you lost the Office files and click the Scan button.
Microsoft Excel Free Download 2019
Step 2. The software will immediately start scanning the drive and very soon the deleted files will show up. When the process is over, you can filter the Office files by clicking 'Filter' > 'Documents'.
Step 3. Select the Office files (e.g. Word, Excel, and PowerPoint) and click the Recover button. You can browse for a different location to save the recovered files.
Microsoft Excel is the largest used Reporting and Data Analysis application now a days. Its important to know the Microsoft Excel version history since the version 1. The table below lists the various versions of Excel for Windows.
VERSION | RELEASED | DESCRIPTION |
---|---|---|
1 | 1985 | Version 1, for the Macintosh was released. There never was an Excel 1.0 for DOS or Windows. |
2 | 1987 | Excel 2.0 is the first version of Excel for Intel platform. |
3 | 1990 | Included Toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features. |
4 | 1992 | The first “popular” version. Included lots of usability features. |
5 | 1993 | A major upgrade. Included multi-sheet workbooks. Visual Basic for Applications (VBA) was introduced in this version. |
7 | 1995 | Known as Excel 95. The first major 32-bit version of Excel. This is the first major version after Excel 5.0, as there is no Excel 6.0. Almost no external changes, but faster and more stable. |
8 | 1997 | Known as Excel 97. A new interface for VBA developers, UserForms, Data Validation, and lots more. This was a major upgrade that introduced the paper clip office assistant and featured standard VBA used instead of internal Excel Basic. It introduced the now-removed Natural Language labels. |
9 | 2000 | Included in Microsoft Office 2000. This was a minor upgrade, but introduced the upgrade to the clipboard where it can hold multiple objects at once. The Office Assistant, whose frequent unsolicited appearance in Excel 97 had annoyed many users, became less intrusive.Can use HTML as a native file format, “self-repair” capability, pivot charts, modeless user forms. |
10 | 2002 | Known as Excel 2002. Included in Office XP. It has a long list of new features, but most of them will probably be of little value to the majority of users. Perhaps the most significant feature is the ability to recover your work when Excel crashes. This version features product activation technology. Please consider the ramifications of this before deciding whether to upgrade. |
11 | 2003 | Known as Microsoft Office Excel 2003. The new features in this version are:
Most users will not find the upgrade worthwhile. |
12 | 2007 | Included in Microsoft Office 2007. This release was a major upgrade from the previous version. Similar to other updated Office products, Excel in 2007 used the new Ribbon menu system. This was different from what users were used to, and was met with mixed reactions. One study reported fairly good acceptance by users except highly experienced users and users of word processing applications with a classical WIMP interface, but was less convinced in terms of efficiency and organisation. However, an online survey reported that a majority of respondents had a negative opinion of the change, with advanced users being “somewhat more negative” than intermediate users, and users reporting a self-estimated reduction in productivity. The new features included in this version are:
|
14 | 2010 | Included in Microsoft Office 2010, this is the next major version after version 12, as version number 13 was skipped. Minor enhancements and 64-bit support, including the following features:
|
15 | 2013 | Included in Microsoft Office 2013, along with a lot of new tools included in this release:
|