Sometimes, while working on Excel, the app may crash or shut down before you’ve done saving your document. Unfortunately, one may forget to save the file before closing the app or the Excel may close automatically when the PC is switched off. Thankfully, Excel allows users to retrieve unsaved data. Let us discuss ways of retrieving data in Excel.
To Recover Unsaved Excel Files
Steps to follow:
1. Open the Excel document.
2. Click on the File tab on the Ribbon located on the leftmost side of the screen.
3. Click on the Manage workbook drop-down menu from the Info page, and then click on the Recover Unsaved Workbooks.
4. A folder that contains unsaved files will open. Click on the folder you want to recover, and then click on the Open button.
5. After opening the unsaved file, click on the File tab on the toolbar.
6. From the Info page, click the Save As button, selecting where you want to save your document.
To turn on the autosave feature
The Autosave Feature in Excel allows the Excel document to save automatically while you are working on it.
Steps to follow:
1. Open the Excel application.
2. Click on the File tab on the menu.
3. Click on the Options button to open the Options dialogue box.
4. From the box, click on the Save button located on the left pane of the dialogue box. . Locate the Save Workbooks section, and check the Save AutoRecover checkbox. Finally, click the OK button.
To change the autosave location in Excel
By default, the unsaved files are saved in the Unsaved Folder found in the Microsoft folder within your PC. Excel allows users to change and add the saving directory where the unsaved files will be saved.
Steps to follow:
1. Open the Excel application.
2. Click on the File tab on the menu.
3. In the File screen, click on the Options button to open the Options dialogue box.
4. From the box, click on the Save button located on the left pane of the dialogue box.
5. Locate the Save Workbooks section.
6. In the Auto recover file location section, add the location where you want to save your documents.
How to keep or not keep the AutoSave Version
When the Excel application closes before saving the document, the Version of the file may change. However, Excel allows users to keep or not keep the version of the file when the file closes before saving. Here are the steps to follow:
1. Open the Excel application.
2. Click on the File tab on the menu.
3. In the File screen, click on the Options button to open the Options dialogue box.
4. From the box, click on the Save button located on the left pane of the dialogue box.
5. Locate the Save Workbooks section.
6. Finally, check or uncheck the Keep the last autosaved version if I close without saving button