You can decide where to save autosave files in Excel and also how long should Excel autosave a document. Tip: Change Excel AutoSave Location and Settings Step 4: When the document open in Excel, remember to click the Save as a button in the yellow bar above your worksheet and save the file to the desired location. Step 3: Select the needed file and click Open. Step 2: Go to the Recover Unsaved Workbooks. Step 1: Click File > Open > Recent Workbooks. To reach the auto-saved Excel files, do as the following steps: Once you close Excel documents without saving, the first thing that you should do when reopen Excel is to recover unsaved Excel files from AutoSave folder where the temporary excel files are stored. Like AutoRecover, AutoSave is turned on by default in Excel, and it also allows users to define the interval of auto saving and the location of the saved excel file. Even if users forget to save the file, they will not totally lose it when something goes wrong. With AutoSave, another built-in feature of Microsoft Excel, a newly created excel file can be saved automatically in a preset interval. Locate and Recover Unsaved Excel Files via AutoSave Folder If you have never saved the file before Excel accidentally stops working, the file will not be recovered. Next time you run Excel, you can see the retrieved file in the Document Recovery pane.īut it should be noted that Excel AutoRecover is not workable unless you have saved the file at least once. When Excel closes unexpectedly without saving your work, don't worry. It can restore the unsaved file to the last saved version. Microsoft Excel now has a built-in AutoRecover feature which can help users retrieve the files if Excel closes unexpectedly due to power failure or computer crash.
Recover Unsaved Excel Files via AutoRecover A good habit of saving Excel files on time and preparing a backup copy will also work to your advantage.
We will also introduce a professional data recovery that can help you out when Excel's built-in features fail to work recover excel files that are not saved. Follow us to see how these features recover unsaved excel files on Excel 2016/2013/2011/2007/2003. But, thankfully, Microsoft Excel has built-in AutoSave and AutoRecover features which can help you avoid losing important data.
If you happen to be working hard on an Excel workbook but forget to save it in time when Excel stops working or if you accidentally close the file without saving it, it would be a big tragedy. (2) If the document was already manually saved, but you lost intervening work between saves, it will have the name of the saved document (e.g, “ Autocovery save of Remove indents.asd“).Computer crash and power failure occur frequently and unexpectedly. (1) If the document is new and never been saved, the file name will be something like “ AutoRecovery save of Document 1.asd"
In the opening AutoRecover file folder, please select the specified ASD file of lost word document, and click the Open button. In the Open dialog box, please (1) press Ctrl + V keys together to paste the AutoRecover file location into the Address box, and press Enter key (2) select All Files from the drop down list right to the File name box, and then (3) double click to open the specified folder that probably contains recovered file. Go ahead to click File > Open > Browse.Ĥ. In the opening Word Options dialog box, please click Save in left bar, copy the folder path from the Auto Recover file location box, and then close the Word Options. Click File > Options to open the Word Options dialog box.Ģ. This method will guild you to find out the Auto Recover file location from Word Options, and then recover files with the Auto Recover file location easily in Word.ġ.