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.
- First, open Microsoft Excel and go to Open > Recent.
- Next click on Recover Unsaved Workbooks under the Workbooks section.
- 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.
- Consequently, here we see the recovered excel workbook (Book1).
- Then save the file by clicking on the Save icon in excel.
- After that, go to Save As > Browse.
- Finally, choose the file location, give a file name and click on Save.
- You will get the unsaved excel files in the below location too. In this location, unsaved files are saved as temporary files.
- 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.
- In the beginning, open the excel file that was overwritten and go to the File tab from Ribbon.
- 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.
- 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.
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.
- 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.
- How to Recover Corrupted Excel Files from USB (4 Quick Methods)
- Recover Permanently Deleted Excel Files Online
- How to Recover Excel File Password (2 Easy Ways)
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.
- Firstly go to onedrive.live.com.
- Now, go to My Files > Documents.
- Next, you will see the uploaded excel files in the OneDrive. Right-click on a specific excel file and press Version History.
- 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.
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:
- Click on the Start menu at first, and search for ‘Restore File’.
- Then click on ‘Restore your files 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.
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.
- Open the excel application, and click on Options.
- 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.
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.
- Go to the upper left corner of the excel window, and move the AutoSave from Off to On.
- Then, give a name to your file and press OK.
- Now the excel file is linked to OneDrive.
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.