How to Downgrade Excel to Previous Version
Regretted saving a file with incorrect data in Excel? No worries, you can revert it back to a previous version. Excel saves versions automatically and you can access them anytime. Let's explore how.
Before we start, make sure you have not closed the work site and the updated file is open. Also, ensure there's nothing critical in the unclosed work site which might be affected by reverting. If all things are well, proceed with the following steps.
Accessing Version History in Excel
Firstly, you need to locate the version history of the file. Remember, this can only be done if there's more than one version of the file saved.
To access the version history, move your mouse pointer to the "File" tab in the Ribbon, then click on "Info" in the left-hand menu. The "Version History" button, located under the 'Manage Versions' section, is what you're interested in.
Checking the Timeline
Clicking on "Version History" will open another window. It presents a timeline showing each version along with the date, time, and the author of the version.
Each mark represents a specific version. Moving your mouse over each mark will reveal a tool tip that indicates the version number and the name of the person who created that version.
Choosing the Desired Version
The next step is to select the salvageable version that you want to revert to. Click on the mark in the timeline that corresponds to the previous version you want to restore.
Once selected, a preview window will open on the right side of the screen. This window mimics the version history with a timeline, but also includes all the different versions of the file. Click on "Open" to revert your file back to the selected version.
Knowing the Limitations
Before proceeding, note that the version history in Excel only saves changes that were made directly in the Excel interface. Deletions or changes made using VBA (Visual Basic for Applications), Power Query, or Power Pivot VBA, won't be captured.
Also, Excel Online's version history only works if autosave is enabled and if the file is being shared within an organization. Personal OneDrive users won't have this feature.
So, now that you know how to manipulate the version history in Excel, always save your work before closing a file, especially when you're doing critical work. But if you ever face the awkward situation of having saved the wrong changes, Excel's got your back. Keep the contents and process in mind and you'll navigate effortlessly.Till next time, enjoy your troubleshooting!