How to Recover an Excel Work File That Wasn't Saved

If you are working on an Excel file and failed to save it at any point before the program crashed or if you closed the file before saving it, you can reopen it if you are using Microsoft Excel 2010. Excel will save the file temporarily, so you should recover the file as soon as possible. However, it is important to remember that even though this is an option, you should always save your work frequently.

...
Do not worry if your system crashes before saving an Excel file.

File Never Saved

Step

Reopen Excel.

Step

Click on "File" in the upper-left hand corner of the screen. Then click "Recent."

Step

Select "Recover Unsaved Workbooks." This will display a list of any workbooks you worked on that were not saved.

Step

Select your file you were working on. Excel will record the time that the file was last worked on, so you can tell which file is the one you want if the time is close to when you closed Excel without saving or Excel crashed.

Step

Click "Open."

Step

Click "Save As" to save your file. You need to name the file and then click "Save."

Files Previously Saved

Step

Open the document you were working on.

Step

Click "File" in the upper left-hand corner of the window.

Step

Click "Info."

Step

Under Versions, click the version labeled "(when I closed without saving)".

Step

Click "Restore."