How to retrieve unsaved Excel files, restore unsaved Excel files
In the process of working with Excel file, there will be times when you encounter problems closing the Excel file without saving the data while editing. You are not sure how to recover, restore unsaved Excel files, so please refer to the following article to know how to retrieve and recover unsaved Excel files.
Here the article shared to you how to retrieve, recover unsaved Excel files, invite you to track.
How to set autosave to automatically save files (AutoRecover) in Excel
Excel supports two very useful features : AutoSave and AutoRecover :
- AutoSave is a feature to automatically save files as soon as you have created but not backed up, instead of having to press Ctrl + S , you can set the time to automatically save files shorter.
- AutoRecover helps you to restore unsaved Excel files when Excel windows are closed but not saved due to problems. It will display the last archive version displayed in the Document Recovery panel when you start the Excel file after the unsaved file problem occurs. AutoRecover only works on saved spreadsheets at least once before the problem can not save the file.
In Excel, by default, AutoSave and AutoRecover are enabled, but you can change the time to automatically save files and folders containing restored files by:
Step 1 : In Excel file, select File -> Options.
Step 2 : On the Word Options window select Save, in the right side you will see two sections Save AutoRecover information every and Keep the last autosaved version if I close without saving are highlighted, if someone accidentally turns off go, then you need to tick to reactivate.
Step 3 : To change the time to automatically save the file you edited in the section Save AutoRecover information every , the unit of time is minutes. If you want to change the directory to save the AutoRecover file by pasting the directory address into the AutoRecover file location section . After setup is complete you click OK to save.
Get back unsaved Excel files
To retrieve unsaved Excel files, be sure to activate the 2 features AutoSave and AutoRecover. How to retrieve and restore unsaved Excel files as follows:
Method 1: If the file you edited has not yet been saved, then when you open that Excel file on the left of the Document Recovery section, select the file with the latest time, the file will display in the Excel content, you can Continue to edit and save the file.
Method 2
Step 1: Open the Excel file, then select File .
Step 2: Next select Open -> Recent -> Recover Unsaved Workbooks.
Or you choose Info -> Manage Workbook -> Recover Unsaved Workbooks .
Step 3: Open the Open window , in the UnsavedFiles folder at the path C: UsersAdminAppDataLocalMicrosoftOfficeUnsavedFiles, select the Excel file name to restore and select Open .
Step 4 : If you want to recover the file, select Save As and choose a location to save the Excel file to retrieve.
Above the article has shared to you how to retrieve and recover unsaved Excel files, so if you have forgotten to save or have not saved the problem, you can also get the most recent data. that you have entered or edited. Good luck!
You should read it
- Restore unsaved text in Word, Excel, PowerPoint
- Steps to retrieve unsaved AutoCAD files
- How to find and recover unsaved word files (save) in Word
- How to Recover Word Documents
- How to compare 2 Excel files to see if there is any difference
- How to recover Word, Excel files when deleted with Data Recovery Wizard
- Simple way to convert Excel files to PDF
- How to retrieve an overwritten Word file
May be interested
- How to calculate the number of days in Excel - Functions, formulas for calculating the number of days in Excelhow to calculate the number of days in excel - functions, formulas for calculating the number of days in excel. in the process of processing data in excel, you will certainly encounter many cases that need to calculate the number of days such as the number of days guests stay, the number of days to perform work ... it will be difficult if the
- Separate text from strings in Excel, for example, and how to do itseparate text from strings in excel, for example, and how to do it. in excel, there are 3 basic functions that help you separate text from strings in excel: left, right, mid. if you are looking to separate words from a string, please refer to the article
- How to use the Copy Paste feature in Excel effectively?how to use the copy paste feature in excel effectively? copy (copy), paste (paste data) feature is familiar and useful when you use excel. but if you're familiar with using ctrl + c and ctrl + v keys to copy and paste data
- How to type fast - Guide you how to practice fast typing without looking at the keyboardhow to type fast - guide you how to practice fast typing without looking at the keyboard. surely you have been inferior to yourself when your typing speed is quite slow to touch and type trigger. of course what you want is how to improve speed
- Choose function in Excel, how to use the Choose function and illustrative exampleschoose function in excel, how to use the choose function and illustrative examples. you are looking for ways to use the choose function in excel so you can use the choose function quickly. so, please refer to the following article to know the choose function syntax, for example how
- DSUM function in Excel, how to use DSUM function and examplesdsum function in excel, how to use dsum function and examples. the dsum function in excel is a fairly common function with a fairly simple usage. but if you do not know how to use the dsum function, you can refer to the following article to understand h