EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Recover Document in Excel
 

Recover Document in Excel

Updated June 8, 2023

Recover Document in Excel

 

 

Excel Recover Document

In this article, we will learn about Recover Document in Excel. This is a story that every one of us has been through more than several times in our professional life. Excel crashes, we lose the data, the report is important, management breaths fire for the time report is not with them, and life becomes hell. A more decent way to tackle this situation is, you can save the Excel file every now and then. But this is not something as easy as it looks to read. You might forget to save the file, and that is quite natural.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

What is Document Recovery in Excel?

Coming straight towards the point, Excel crashes frequently, and that frequently is something when you don’t want it to crash. If you have saved the file, all is well and good. If you do not, then there are things to worry about. For such users, who tend to forget to save files, Excel has some useful features that come in handy. In this article, we will see some features that allow a user to recover files that are not saved. Let’s see these methods one by one and step by step.

Excel AutoSave and AutoRecover Tools

We all are fortunate enough to have AutoSave and the AutoRecover option available under Excel, which helps us by allowing Excel to automatically save the worksheet after the stipulated time (for example, after every 10 minutes or so). The AutoRecover option allows you to recover the documents in Excel as well. However, you need to enable the AutoSave option for the same to work out in Excel. Follow the steps below to enable the same in Excel to save the worksheet automatically after a specific time.

You can see the Excel AutoSave option in Excel at the upper side ribbon. It is a switch kind of structure in which you can turn it ON and OFF at your convenience. See the screenshot below:

Step 1: Open a new Excel file and click on the File tab present under the uppermost ribbon in Excel.

Recover Document in Excel Example 1

Step 2: Out of all the file operations available, click on the Options tab at the bar’s end.

Recover Document in Excel Example 2

A new Excel Options window will pop up when you click on the Options tab.

Step 3: Click the Save option under the list of options on the left-hand side under the Excel Options tab.

Recover Document in Excel Example 3

Step 4: On the right side of the window, you’ll see all options associated with saving a file under Excel as soon as you click the Save button. Multiple file-saving options exist for AutoSave and AutoRecover under the Save Workbooks section, as shown below.

Recover Document in Excel Example 4

If you look closely, all these options are already tick selected and set to their default option values. However, you have all the leverage to change some of the custom values.

Step 5: If you see Save AutoRecover information in every tick box, it has a default value set to 10 minutes. Meaning the file will automatically save after every 10 minutes. However, you might want to reduce this file auto-saving time. Well, it is under your control, and you can reduce or increase it. I will change it to 2 minutes rather than 10 minutes, and now, the file will automatically save after every 2 minutes.

Recover Document in Excel Example 5

Step 6: Moreover, if you need to change the AutoRecover file location, you can also change this one. By default, all recovered files will store at C:\Users\dell\AppData\Roaming\Microsoft\Excel\ this path.

AutoRecover file location Example 6

Do you see? Enabling these AutoSave and AutoRecover options is a great help for us. We can easily save the workbooks and recover those in case of any unfortunate event. Now, we will see how to Recover the Documents when Excel is crashed due to some unexpected error.

How to Recover an Unsaved Document?

Follow the steps below to recover a document that you failed to save.

Step 1: Click the File tab under the newly opened Excel file.

Recover Document in Excel Example 1

Step 2: Out of all the file options, choose Open and click on it.

File Options Example 2

Step 3: Once you click on the Open option on the right-hand side, you’ll see all the possible operations under the section. At the bottom of all those, you can see an option named Recover Unsaved Workbooks. Click on it.

Unsaved Workbooks Example 3

Step 4: When you click the Recover Unsaved Workbook option, a window will appear where all your unsaved workbooks are stored. Click on the desired file and hit the Open button to open it.

Unsaved Workbook Example 4

Step 5: Once the file is opened, you’ll see a message at the uppermost pane, as shown below:

Recover Document in Excel Example 13

This means you need to temporarily save the file on your local system and save it as an Excel file to access it anytime soon. Make a copy of the same by saving the file on another location of your drive. This way, you can recover the document that was not saved.

Recover Document in Excel Example 14

This is how you can recover the unsaved document under Excel.

Things to Remember

  • All recovered files are stored in Excel binary format by default, which reads with the extension (.xlsb). However, binary format will cause you to lose some data if you try to make a copy of Excel under the same format. Instead, saving the file under .xlsx format or some other format but not the binary is recommended.
  • Setting the AutoSave time is a smart way. However, you need to be smarter enough to set that time. I have set it to 2 minutes here in my worksheet. Because I wanted the most recent data up to 2 minutes in the worst case, I lost the unsaved file due to a system crash or other discrepancies. You can set this time under Save AutoRecover Information Every option in Excel.

Recommended Articles

This is a guide to Recover Documents in Excel. Here we discuss how to enable the Autosave option and Recover Document in Excel, which is not saved. You may learn more about Excel from the following articles –

  1. Logical Functions in Excel
  2. Plots in Excel (Examples)
  3. Unprotect Excel Workbook
  4. Surface Charts in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA Login

Forgot Password?

🚀 Limited Time Offer! - 🎁 ENROLL NOW