Then, in the Manage Versions button, you’ll see all autosaved versions of your document.Įxcel automatically saves workbook versions at specified intervals but if you have made changes to the spreadsheet between these intervals.Click on the FILE tab > select Info on the left-hand side.
#How to recover previous version of excel file 2013 how to
Here know how to recover the overwritten Excel file: This is helpful if you have done any mistake and can’t undo, or your data gets overwritten. In Excel 20 you are having an option to recover the previous versions of your documents. Click on the Save As button, in the yellow bar above your worksheet and save the file to the desired location. The document opens in Excel and will prompt you to save it. Please Note:You can also, go to FILE > Info > open the Manage Workbooks drop-down > select Recover Unsaved Workbooks from the menu.Īnd when the Open dialogue box pops up, select the necessary file > click Open. Now scroll down > click on Recover Unsaved Workbooks button.Then, in this case, know how to recover unsaved Excel file. And after a few seconds, you recognize you haven’t saved the workbook. If in a case while working on a new Excel file, the program locks up unexpectedly. You can also change the Excel AutoRecover file location and specify AutoRecover exceptions.Īs the Excel is configured to AutoSave and AutoRecover your document you can easily restore unsaved Excel file when something went wrong.įurthermore, in this article find out how to recover new files created just now or already saved. You can increase or decrease the time period as per your recommendation. The AutoRecover feature is by default set to automatically save changes of your workbook in every 10 minutes. Assure both “ Save AutoRecover information every X minutes and Keep the last autosaved version if I close without saving” are checked.
And this option by default comes ON in Excel file. Moreover, these two features are amazing to recover unsaved Excel workbooks or restore overwritten Excel files. This feature only works on Excel workbooks that have been saved at least once, otherwise, the Document Recovery pane won’t show up in Excel. With this, you can recover the last saved version displayed in the Document Recovery Pane, when the Excel file is started next time. This helps the user to recover important data that have been lost due to power failure or crash.Įxcel AutoRecover allows the user to restore the unsaved files lost after an accidental closure and other unexpected reasons. Utilize the Excel AutoSave and AutoRecover FeatureĮxcel Autosave and AutoRecover are the two best features that help the user to recover unsaved Excel file data if they are enabled.Įxcel AutoSave is a tool that automatically saves a new document that was created just now but hasn’t saved yet.
0 kommentar(er)
