Enter the number of minutes you’d like between autosaves in place of the X. Check the Save AutoRecover information every X minutes box.Select Options and then choose Save from the dialog box.You can choose the time interval of the AutoRecover feature by doing the following: The extent of data loss – how much of the file has been saved – will depend on the AutoRecover setup. Find the latest version of the document by checking the time stamp.When it opens, you’ll see the Document Recovery pane on the left side.Open Excel and or any Excel workbook on your computer.When your computer is back on again, follow these steps: Somehow this always seems to happen at the worst time.įortunately, Microsoft Office has a recovery protocol for such occasions. But what happens if you’ve saved the file but then your computer crashes?Ī lot of things can go wrong, like Excel freezing or your computer restarting unexpectedly. Locating a copy of an unsaved Excel file is relatively easy, as the program creates a helpful backup. How to Recover Unsaved Excel File After a Restart or Crash However, the AutoSave feature will only work if you save the Excel file in OneDrive. So, Office 365 not only helps you retain data but also provides a clear overview of every version of the file and its modifications. On the right side of the window, you’ll see all the versions of the file, along with who modified it and when.If you need to check the previous versions of the specific Excel file, tap on the file name at the top of the window and select Browse Version History.You’ll be prompted to save the file in OneDrive.Open a new Excel Workbook and move the AutoSave button at the top-left corner from Off to On.However, you need to make sure you’re signed into your Office 365 account to ensure it works. One of the best parts of this package is the AutoSave feature available for World, PowerPoint, and Excel.īy utilizing AutoSave, you never have to worry about unsaved files, and everything you work on is automatically being saved on OneDrive. Since Office 365 is cloud-based, users can store their files in OneDrive, the cloud-based storage service that comes with the subscription. Understanding the AutoSave Feature in Office 365 Find the unsaved file in the dialog box and make sure to save it in a new location.Click on the Recover Unsaved Workbooks at the very bottom of the window.Open Excel, start a new Workbook, and then go to the File tab.
So, if you’re dealing with losing an unsaved Excel file, here’s how to get it back: When it comes to recovering unsaved Excel files, this subscription-style spreadsheet program works the same as Microsoft Office 2019. Some Excel users are happy to work with on-premises Excel versions, but others choose the cloud-based Office 365 version. How to Recover Unsaved Excel File in Office 365 Also, make sure to save the Excel file in a different folder. Checking the date of creation is the easiest and fastest way to find the Excel file. You may run into the problem of not being sure which file is the one you’re looking for as the file is unnamed. Select the “ TemporaryItems” folder, select the unsaved Excel file and select “ Restore.”.Enter the “ open $TMPDIR” command, which will open the folder with temporary files.