Version History Issues

How to Retrieve an Older Version of an Excel Worksheet

Maira Mehtab Sep 20, 2026 868 views

Question details

The user needs to recover a previous version of an Excel workbook or restore a worksheet that was accidentally deleted or modified.

Product: Excel
Device & OS: not provided
Scenario: Accidentally modifying or deleting a worksheet and needing to revert the file to a prior state.
Observed behavior: The user is looking for reliable methods to access and restore an older iteration of their spreadsheet document.

Before you start

Before attempting recovery, check if your file is saved locally or synced to a cloud service like OneDrive or SharePoint, as the recovery method will depend entirely on your storage location.

Solution 1

Discard Unsaved Changes by Closing the File

If you just made the mistake and haven't manually saved the file yet, closing it without saving is the quickest way to revert to the previous state.

This method is only viable if the workbook has not been saved since the unwanted changes or deletion occurred. It works best for local files where auto-save is turned off.

Close the workbook

Click the 'X' in the top right corner of the Excel window or go to File > Close.

Choose not to save

When the prompt appears asking if you want to save changes to the document, click 'Don't Save'.

Reopen the file

Locate and reopen your Excel file. It will load the exact state it was in during your last successful save, with the worksheet intact.

Data Loss Warning: This method will completely discard all other legitimate unsaved changes you made during the current session.

Solution 2Recommended

Restore Using Version History (OneDrive or SharePoint)

For files synced to Microsoft cloud storage, you can easily browse and restore previous file iterations using the built-in Version History feature.

Solution 3

Recover Local Files on Mac using Time Machine

If you are using a Mac and have Time Machine enabled, you can recover a locally saved older copy of your Excel file.

Built-in File Backup

Use WPS Office to Easily Manage Spreadsheet Versions

WPS Office provides robust local backup and cloud sync features, allowing you to easily recover older versions of your spreadsheets without complex setups.

1. Open your spreadsheet in WPS Office: Launch WPS Spreadsheets and open the document you wish to manage.
2. Check local backups: Go to Menu > Backup and Recovery > Auto Backup to view and recover locally backed up versions of your active files.
3. Access Cloud Version History: If you saved the file to WPS Cloud, click on the File Name at the top center of the application and select 'History Version' to view and restore an earlier iteration.

High compatibility with Microsoft Excel formats (.xlsx, .xls).Built-in Auto-Backup feature protects local files against accidental deletions.Integrated WPS Cloud storage maintains file version history automatically.Lightweight, fast, and completely free to use for basic daily tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Can I recover an older version of an Excel file if I don't use OneDrive?

Yes, if you have local system backups enabled, such as File History on Windows or Time Machine on macOS. Alternatively, if AutoRecover was active during a crash, you might find temporary drafts by navigating to File > Info > Manage Workbook > Recover Unsaved Workbooks.

Where exactly is the Version History button in Excel?

If your file is stored in OneDrive or SharePoint and AutoSave is turned on, you can find the Version History option by clicking directly on the file's name in the top title bar. You can also access it by clicking File > Info > Version History.

What happens to my current file if I restore an older version?

When you click 'Restore' on an older version from cloud storage, it replaces your current document, making the older version the active one. If you want to keep the current version as well, choose the 'Save a Copy' option instead.

Does WPS Office support Excel version history recovery?

Yes, WPS Office supports full document recovery through its Auto-Backup center for local files, and offers a robust 'History Version' feature for documents saved in WPS Cloud, fully supporting standard Excel formats.

Document & File Issues