Closing a program without saving happens to everybody at some point. Programs and computers crash, you sometimes simply forget to save your work, or you accidentally overwrite a file. Although this may seem like the end of the world, it's not necessarily the end of your workbook. If Excel 2013 crashed, you may see a document recovery option when you restart the program, allowing you to save the file. If this doesn't work, Excel has a couple of other solutions. AutoRecover helps restore files you've saved in the past; AutoSave works with files you've never saved.
Recover a Previously Saved Excel File
Check your recovery options in Excel's Start screen. If Excel crashed, you may see a Recovered area. If you do, select Show Recovered Files to open the Document Recovery pane in a new workbook. Find your file in the pane and open it. If you don't see this option, select the file from the Recent area.
Video of the Day
Check your workbook to see if it contains your most recent work. If so, select Restore and OK.
If your workbook isn't up-to-date, open the File tab and go to Info. Look in the Versions area for a file description ending with the words when I closed without saving. Select the file to open the workbook. Check the file to make sure it contains your recent changes. Select Restore on the Recovery message and OK on the overwrite confirmation message.
Recover an Unsaved Excel File
Select Open Other Workbooks on the Excel Start screen. Scroll down the next screen and select the Recover Unsaved Workbooks button to open the temporary file location where Excel stores unsaved files.
Select your workbook from the list. Use the date-modified data to identify the file, as Excel doesn't give it an easily identifiable name. Select Open.
Check you've opened the correct workbook containing recent data. Select Save As and save the file to your computer.