How to Recover File after Crash in Excel (4 Methods)

In this article, I will discuss how you can recover an unsaved excel file after a crash. A crash can happen due to several reasons. For example, your PC can crash or a sudden failure of the excel application. Sometimes, you may forget to save the excel file before closing your PC too. All these situations are painful. But don’t worry, there are ways to recover excel files. Let’s learn about those solutions.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


4 Methods to Recover Excel File after Crash

1. Recover Unsaved Excel File after Crash or Restart

Let’s consider you have opened a new excel workbook (Book1) from your PC or updated a pre-existing workbook. However, you forget to save the file before shutting down your PC, or the Excel application got crashed for some reason. Now, how can you recover the unsaved workbook? Follow the below steps to recover the unsaved excel file.

Steps:

  • First, open Microsoft Excel and go to Open > Recent.

Recover Unsaved Excel File after Crash or Restart

  • Next click on Recover Unsaved Workbooks under the Workbooks section.

Recover Unsaved Excel File after Crash or Restart

  • As a result, excel will show the list of the unsaved files (both overwritten and never saved ones).
  • Now double-click on the file you want to recover.

Recover Unsaved Excel File after Crash or Restart

  • Consequently, here we see the recovered excel workbook (Book1).

Recover Unsaved Excel File after Crash or Restart

  • Then save the file by clicking on the Save icon in excel.

Recover Unsaved Excel File after Crash or Restart

  • After that, go to Save As > Browse.

Recover Unsaved Excel File after Crash or Restart

  • Finally, choose the file location, give a file name and click on Save.

Recover Unsaved Excel File after Crash or Restart

Note:

  • You will get the unsaved excel files in the below location too. In this location, unsaved files are saved as temporary files.

C:\Users\User\AppData\Roaming\Microsoft\Excel

  • In the case of never saved excel workbooks, when you go to Open > Recent > Recover Unsaved Workbooks, the below dialog will show up. So, you can open the unsaved file from this dialog too.

  • By default, unsaved excel files are backed up in .xlsb format. You can choose the file format while restoring the file.

Read More: [Fixed:] Unsaved Excel File Not in Recovery


2. Restore Overwritten File after Crash in Excel

Suppose you have updated a previously created excel file and saved the changes. Or, after overwriting the excel file, you face a PC crash. However, now you need the older version of the file. What will you do? Let’s have a look at the below steps to recover the older version of the excel file we have discussed.

Steps:

  • In the beginning, open the excel file that was overwritten and go to the File tab from Ribbon.

Restore Overwritten File after Crash in Excel

  • Next, go to Info > Manage Workbook to see the list of the versions of the file.
  • Now choose the version you want to open and click on it.

Restore Overwritten File after Crash in Excel

  • As a consequence, the previous version of the excel file will be visible. But remember, this recovered file is read-only. Make sure you have restored the file and saved it as a separate file.

Restore Overwritten File after Crash in Excel

Note:

You can see the version history of an overwritten excel file by following the below steps too.

  • Open the specific excel file, and go to the File tab.
  • Then go to Info > Version History.

Restore Overwritten File after Crash in Excel

  • As a result, you will get the history of the different versions of a particular excel file.
  • Afterward, you can open any version by double-clicking on it.
  • Later you can restore the version too.

Read More: How to Recover Overwritten Excel File with No Previous Version


Similar Readings


3. Recover Overwritten Excel File Saved on OneDrive

In this method, I will discuss how you can recover overwritten excel files located in OneDrive. The advantage of OneDrive is that even if you face a PC crash, your file is still saved to the OneDrive. Follow the below steps to restore excel files from OneDrive.

Steps:

Recover Overwritten Excel File Saved on OneDrive

  • Next, you will see the uploaded excel files in the OneDrive. Right-click on a specific excel file and press Version History.

Recover Overwritten Excel File Saved on OneDrive

  • As a result, the excel file will open in a different tab with version histories (Current and Older). Choose the version you require and restore it.

Read More: How to Backup Excel Files to a Flash Drive (4 Useful Methods)


4. Restore Previous Version of Excel File with File History

You can recover overwritten excel files if File History is enabled in Windows. If you experience a crash, the excel file is backed up to File History. Steps to find the excel files in the File History location are:

Steps:

  • Click on the Start menu at first, and search for ‘Restore File’.
  • Then click on ‘Restore your files with File History.

Restore Previous Version of Excel File with File History

  • As a result, the File History window will appear. Locate the backed-up excel file and using arrow keys see which versions are available for it.
  • After that, restore the excel file separately if you need it.

  • On my PC, File History is not enabled, so here we can see no excel file.

Read More: How to Recover Previous Version of Excel File (4 Easy Ways)


Activate AutoSave and AutoRecovery Option in Excel

Make sure you have activated AutoSave and AutoRecovery options in Excel. To configure these settings follow the below steps.

Steps:

  • Open the excel application, and click on Options.

Activate AutoSave and AutoRecovery Option in Excel

  • After that, the Excel Options dialog box will show up. Select the Save option.
  • Now, from the Save Workbooks section, put a checkmark on ‘Autosave files stored in the cloud by default in Excel’.
  • Then tick the ‘AutoRecover information every’ option and set the time. By default, excel sets this time as 10 minutes. However, you can change the time. For instance, I have set the time as 1 minute.
  • Next, put a checkmark on ‘Keep the AutoRecovered version if I close without saving’. If you want you can change the location from here.

Read More: How to Auto Backup Excel File (2 Easy Methods)


How Does AutoSave Work in Excel 365?

Excel 365 has the advantage of saving the excel files in OneDrive. This is very much helpful as you can recover files from OneDrive after a crash happens. While working, if you want to save excel files to OneDrive follow the below steps.

Steps:

  • Go to the upper left corner of the excel window, and move the AutoSave from Off to On.

How Does AutoSave Work in Excel 365?

  • Then, give a name to your file and press OK.

  • Now the excel file is linked to OneDrive.

Conclusion

In the above article, I have tried to discuss several methods to recover an excel file after a crash elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.


Related Articles

Hosne Ara

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo