how to revert excel to previous version

How to Downgrade Excel to Previous Version

By Nicole Taylor
AD
Sure, I'll assist you in providing an SEO-friendly and human-like content for "How to Revert Excel to Previous Version". Follow the mentioned rules strictly.

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.

AD
The easiest ways to convert excel to pdf
The easiest ways to convert excel to pdf
Master Excel in 30 Days: Your Roadmap to Data Mastery! 🚀
Master Excel in 30 Days: Your Roadmap to Data Mastery! 🚀
#Excel #Tricks: Remove formula but keep the values or numbers or results
#Excel #Tricks: Remove formula but keep the values or numbers or results

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.

how to delete bankrows in excel with the title'how to delete bankrows in excel '
how to delete bankrows in excel with the title'how to delete bankrows in excel '
Best Excel tutorial on the internet
Best Excel tutorial on the internet

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.

AD

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.

AD

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!

AD