We use cookies on this website. By using this site, you agree that we may store and access cookies on your device Read More Got it!
File Repair 4 minute read

How to Restore Previous Version of Excel File?

Priyanka Chauhan
Written By
Priyanka Chauhan
Alexis Llontop
Approved By
Alexis Llontop
stellar calander
Updated on
January 12th, 2023

Summary: If you’ve accidentally closed the Excel file without saving it, then you can restore the previous version of the file using the inbuilt features in Excel and Windows. This article discusses the ways to restore the previous version of the Excel file. Further, it discusses an Excel file repair tool that can help repair and restore corrupt Excel files. Sometimes, while working on an Excel file, you accidentally close the file or your system shuts down suddenly due to power failure or the Excel program crashed due to an issue. As a result, the file you’re working on will not be saved and you fear losing your data. However, there is no need to worry as the Excel program has features that can help you restore such unsaved files. One such feature in the Excel application is the AutoRecover feature. If this feature is enabled, it automatically saves the versions of the file. In this article, we’ll mention different ways to restore the previous version of the Excel file.

Free Download for Windows

Methods to Restore Previous Version of Excel File

Follow the below-listed methods to restore the previous version of the Excel file using the inbuilt functions of Excel and Windows.

Method 1: Use Document Recovery Pane in Excel

The Document Recovery pane in Microsoft Excel helps to review, open, and save the recovered files. If your Excel program closes unexpectedly before saving the changes, you can use the Document Recovery pane to restore the file.

Here are the steps to restore the file using the Document Recovery pane:

  • Open the Microsoft Excel.
  • Click on Show Recovered Files.
  • The Document Recovery Pane appears, showing the recovered files.

Method 2: Use the Manage Workbook Option in Excel

Manage Workbook is an inbuilt feature in Excel that you can use to recover the previous version of the Excel file. If your Excel file is closed without saving, this option can help you to open the file and save it. Follow these steps to restore the file:

  • Open the Excel program.
  • Go to File > Info.
  • Choose the Manage Workbook option.
  • Click Recover Unsaved Workbooks.
  • Choose the desired file and click Open.
  • When the file is open, go to the File tab and select the Save As an option to save the file.

Method 3: Use File History Feature in Windows

You can also restore the previous version of the Excel file by using the Windows File History feature. However, to use this feature, you must have enabled it beforehand. Here are the steps:

  • First, choose the desired file on your system.
  • Right-click on File and select the Properties tab.
  • In the dialog box that opens, click the Previous Versions option.
  • Then, click the Recover Previous Version of Excel File option.
  • Click on the required file from the list of earlier versions.
  • Hit Open and then click OK.

What if the file doesn’t open?

If the Excel file doesn’t open, it indicates corruption in the file. An Excel file may get corrupt due to an abrupt system or program shutdown, system or application crash, etc.

When Microsoft Excel detects a corrupted worksheet upon opening, it automatically starts File Recovery mode and starts repairing it. However, if the File Recovery mode failed to start, then you can use the Open and Repair utility in Excel to recover the corrupted workbook. Follow these steps:

  • Click File > Open.
  • In the Open dialog box, choose the corrupted workbook.
  • Click the arrow next to the Open tab and click the Open and Repair option.
  • To recover as much as data from the workbook, click Repair.
  • Click Extract Data to extract values and formulas from the workbook, if Repair is not able to recover your data.

If the Open and Repair tool does not work, then you can use advanced Excel repair software, such as Stellar Repair for Excel. This Excel repair software can easily repair severely corrupted Excel files and recover all the data in just a few steps. 

Stellar Repair for Excel

Conclusion

You can use the methods mentioned above to restore the previous version of the Excel File. If the file is corrupt, you can repair the file using Microsoft’s Open and Repair tool or use a professional Excel file recovery tool, such as Stellar Repair for Excel. This tool can repair severely corrupted files and restore all the Excel file data with complete integrity. You can download the free version of the software to scan the corrupt Excel file and preview the recoverable data.

About The Author

Priyanka

Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.

Best Selling Products

Stellar Repair for Excel

Stellar Repair for Excel

Stellar Repair for Excel software provid

Read More
Stellar Toolkit for File Repair

Stellar Toolkit for File Repair

Microsoft office file repair toolkit to

Read More
Stellar Repair for QuickBooks ® Software

Stellar Repair for QuickBooks ® Software

The most advanced tool to repair severel

Read More
Stellar Repair for Access

Stellar Repair for Access

Powerful tool, widely trusted by users &

Read More

Table of Contents    arrow

Categories

offer banner

Related Posts

related post
File Repair

How to Fix the #Value! Error in Excel?

Stellar Author Monika Dadool January 25, 2023 Read More
related post
File Repair

[2023 Fix]: An Unexpected Error has Occurred. Changes to your Data cannot be Saved

Stellar Author Monika Dadool January 24, 2023 Read More
related post
File Repair

How to Fix Excel Run-Time Error 1004?

Stellar Author Monika Dadool September 28, 2022 Read More

Free Trial for 60 Days

Stellar Official Website

Stellar Data Recovery Inc.
48 Bridge Street Metuchen,
New Jersey 08840,
United States

ALSO AVAILABLE AT

Partner Logo

About

  • About us
  • Career
  • ISMS Policy
  • Privacy Policy
  • Terms of Use
  • License Policy
  • Refund Policy
  • End User License Agreement

RESOURCES

  • Blog
  • Articles
  • Product Videos
  • Knowledge Base
  • Case Studies
  • Whitepapers
  • Software Catalog

NEWS & EVENTS

  • News
  • Events

PARTNERS

  • Affiliates
  • Resellers
  • Distributors

Useful Links

  • Contact Us
  • Support
  • Special Offers
  • Student Discounts
  • Awards & Reviews
  • Downloads
  • Store
  • Sitemap
Follow Us

tw in yt

Stellar & Stellar Data Recovery are Registered Trademarks of Stellar Information Technology Pvt. Ltd. © Copyright 2023 Stellar Information Technology Pvt. Ltd. All Trademarks Acknowledged.

Hippa Logo tuv footer partner logo DMCA.com Protection Status