How to Restore Previous Version of an Excel File | Guide

Recovering the version of accidentally deleted Excel file: three methods and data recovery tools

Accidentally deleted important cells or data in Excel worksheets? don’t worry! This article will introduce three ways to recover previous versions of Excel files to help you easily retrieve lost data.

Methods for recovering previous versions of Excel

Microsoft Excel is a widely used spreadsheet editor. During use, you may modify the table contents by mistake, or close the file without saving. In this case, you may need to find their previous versions and restore them. Fortunately, this is completely feasible.

The following are three ways to restore previous versions of Excel files:

Method 1: Recover the previous version from file attributes

Previous versions of files will be preserved as long as you enable file history or Windows backup and restore. You can follow these steps to view and restore previous versions of Excel files:

1. Right-click on the target Excel file and select Properties from the context menu.
2. Go to the Previous Versions tab. Previous versions of Excel files will display modification time. Select the version you want and click Restore to restore.

Method 2: Recover the previous version from the automatic recovery file location

Excel provides automatic recovery function, which can automatically save unsave files in case of system failure, unexpected power outage, application crashes, etc. How to restore previous versions of Excel files using the automatic recovery feature? See the following details:

1. Open the Excel file and click File > Information > Manage Workbooks > Recover Unsaved Workbooks.

2. Select the target unsave version and open it. After confirming that the correct file is found, save it to your computer.

Alternatively, you can go directly to the AutoRecover file location to find the required file:

C:\\Users\\您的用户名\\AppData\\Roaming\\Microsoft\\Excel

Method 3: Recover from Excel file history

If your files are stored in OneDrive or SharePoint on Microsoft 365, you can find previous versions of the files from the history. Open the file you want to view and go to File > History. After that, you can select a version and open it in a separate window.

How to Recover Deleted Excel Files on Windows

All of the above methods are suitable for restoring historical versions of Excel files. Next, we will explain how to recover deleted or lost Excel files.

To recover deleted Excel files, you should first check the Recycle Bin. If the lost project is not there, you need to use professional and reliable file recovery software. MiniTool Power Data Recovery is the most recommended among many secure data recovery services.

This file recovery tool offers a free version that allows you to recover 1 GB of files for free. You can download and try it out.

Step 1. Start MiniTool Power Data Recovery Free. On its homepage, select the drive where the missing Excel file resides and click the Scan button. You can choose to scan the desktop, recycle bin, or specific folders separately.

Step 2. After the scan is complete, find the required file and double-click the preview.

Step 3. Finally, select the desired Excel file and click the "Save" button to save.

Summarize

How to restore previous versions of Excel files? Just follow the above method. To ensure data security, be sure to enable file history or Excel automatic recovery.

The above is the detailed content of How to Restore Previous Version of an Excel File | Guide. For more information, please follow other related articles on the PHP Chinese website!