Then copy the path to the folder specified in the box Auto save file path (for.

To do this, first identify the save folder Temporary Excel files by clicking on the menu office hour located in the upper left, going to the tab Options and then in the tab saving, attached to the window that appears later. If this option is not present, it is very likely that Excel was unable to generate a temporary draft of the workbook: in that case, you can try to retrieve the saved files automatically using the manual procedure. Finally press the button good To confirm the changes. To limit the likelihood of data loss during recovery, you can decrease the time interval between Excel auto-save operations, which by default corresponds to 10 minutes : to do it, go to the card office hour and click first on the item Options and then in that saving located on the left side of the screen that is proposed.įinally, put a check mark next to the article Save the auto save information every, specify the time interval (in minutes) in the immediately adjacent text field and also check the box Keep the latest version automatically restored if it closes without saving. Alternatively, you can directly open the spreadsheet that you couldn't save to find yourself directly on the file recovery screen.Īt this point, all you have to do is move your mouse to the version of the book you want to retrieve (helping you, if necessary, with the date of the last time you saved), click Arrow down located in your correspondence and choose whether display the document in the current window, Save as a copy of the file or search the restored document, thus eliminating automatic saving. In practice, what you have to do is open the program and take a look at its left panel: search for the item Show recovered files, identified by a folder icon, and click on it to enter the recovery phase. If, on the other hand, you do not use Office 365 or if you have not activated cloud data synchronization, the question is slightly different: it will be the same Excel that, on the first start after the unexpected shutdown, will restore the files that it failed save manually, retrieving them from an automatically created file locally.

Backup temporary available (you will see a special box when you open the program). For this reason, if Excel closes abnormally, you will simply have to reopen the document of your interest as usual and access the latest one. If you use the version of Microsoft Excel included in subscription to Office 365 and you've synced your data with your Microsoft account, don't worry about losing your files - the program can, in fact, create automatic saves on OneDrive.

Recover latest version of excel file