Sometimes, the Pc or the editor may shut while you are still working on the Sheet. You may not have saved the document before the pc or editor shut, meaning you do not have a copy of the file. Thankfully, Google Sheets and Excel allows user to recover unsaved files. This post will discuss ways of recovering unsaved files in Google Sheets and Excel.
To recover unsaved files in Google Sheets
Table of Contents
Steps:
1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).
2. On the opened Sheet, click on the File tab on the menu.
3. Then, hover the mouse over the Version History button from the menu and select the See Version History button.
4. On the version history screen, you can easily track changes and recover unsaved files.
5. To restore a version, click the Restore this Version button.
To Turn on auto-recovery in Google Sheets
Steps:
1. On the opened Sheet, click on the File tab on the menu.
2. Then, hover the mouse over the Version History button from the menu and select the See Version History button.
3. At the bottom part of the pane, check the Show changes button. By doing so, you’ll have turned on the autosave feature.
To turn off the autosave feature.
Steps to follow:
1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).
2. From Google Apps, click on the Sheets icon and select the existing Sheet.
3. On the opened Sheet, click on the File tab on the menu.
4. Then, hover the mouse over the Version History button from the menu and select the See Version History button.
5. At the bottom part of the pane, uncheck the Show changes button. By doing so, you’ll have turned off the autosave feature.
To recover unsaved files in Excel.
Steps to follow:
1. Open the Excel document.
2. Click on the File tab on the toolbar.
3. Click on the Manage workbook drop-down menu from the Info page.
4. Then, click on the Recover Unsaved Workbooks.
5. A folder that contains unsaved files will open. Click on the folder you want to recover, and then click on the Open button.
How to save recovered files
Steps:
1. After opening the unsaved files, click on the File tab on the toolbar.
2. From the Info page, click on the Save As button.
3. Select where you want to save the files.
To turn on the autosave feature.
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. Locate the Save Workbooks section, and check the Save AutoRecover checkbox. Finally, click the OK button.
To change the autosave location in Excel
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.
5. Locate the Save Workbooks section.
6. In the Auto recover file location section, add the location where you want to save your documents.