Applies to: Excel for Office 365, Excel 2019, SharePoint Online, Excel 2016, Office for business, SharePoint Server 2016, SharePoint Foundation 2013, SharePoint Server 2013 Enterprise, SharePoint Foundation 2010, SharePoint Server 2010, SharePoint Online Small Business, Windows SharePoint Services 3.0.
If your SharePoint lists or libraries are configured to track versions, you can restore a previous version of a list item or file. To learn how you can delete a version, all versions, or just minor versions of an item or file if your list or library is configured for it see Delete a previous version on an item or file in SharePoint. To turn versioning on, see Turn on version history in SharePoint.
Updated November 21, 2016 thanks to customer feedback.
Restore a previous version in SharePoint
- Launch the list or library from the Quick Launch bar.
If your list’s or library’s name of your list is not displayed, select Site contents or View All Site Content, and then press the name of your list or library.
- Right-click on the space between the item or document name and date, and then pick Version History from the menu. You might need to scroll the menu to see Version History.
If you don’t see Version History, click the ellipse (…) in the dialogue and then click Version History.
You’ll see a list of versions of the file.
- In the Version History dialogue, hover next to the version you want and click the down arrow on the right side to get a list of options. Click Restore.
- Click OK to restore the current version as the latest.
Note: SharePoint doesn’t remove the earlier version you just restored, it creates a copy and makes it the latest version.
Turn on Version History in SharePoint
Version History is activated automatically in SharePoint, but if you don’t see the Version History command, version history may be switched off. Based on how your administrator has set up SharePoint, you may be able to toggle on list or library versioning.
For information about SharePoint versioning settings, see Enable and configure versioning for a list or library.
Not sure which version you have? See Which version of SharePoint am I using?