How to restore the data before saving when excel saved it by mistake

作者:丘仲晏 | 发布日期:2024-09-21 18:32:40

本文目录一览⒈How to restore the excel file after saving it?
1. Enter Excel, and then click the file option in the upper left corner
2. Find the bottom option button in the pop-up window on the left, and click "Options".
3. After clicking, the excel options page will appear. At this time, click the save button and set the automatic reply information saving interval to 1 minute.
4. Then modify the content in the source file in the interface. After the modification is completed, wait for more than a minute to restore the pre vious document.
5. Find the path location in the save button on the excel options page. Double-click the file to see the restoration of the pre vious document. The above are all the steps.
1. After saving the excel form, you can return it by undoing the operation.
2. After you save the excel table, if you find that the saved results are not as expected, you can use the undo operation to return to the pre vious state. This will restore the table contents to the time before saving.
3. In addition, if the excel table you saved has been closed, but you want to restore it to the pre vious version, you can try to use the "Version History" function in the "File" menu, so that you can retrieve the different versions you saved before. form.
⒉How to restore data before saving in excel How to restore data before saving in excel
1. Find the "File/Round Button in the Upper Left Corner" on the menu bar, click it and select "Options".
2. In the pop-up "Excel Options" window, click the "Save" button and set the "Save automatic recovery information interval 10 minutes" to 1 minute.
3. After setting up, we quickly modify the content in the table, save and wait for 2 minutes, and then start to retrieve our original version.
4. Go back to where you set the automatic save time interval and find the save path. The general address is under "C:\Users\[local account name]\AppData\Roaming\Microsoft\Excel\". You can see that under this folder, there is a folder named after the current excel file name.
5. Enter the folder, which may contain one or more saved documents. Click on any document to view the pre vious archived files. This solves the problem of how to restore Excel before saving.
⒊Excel accidentally saved and overwritten the pre vious document
Excel accidentally saved and overwritten the pre vious document. You can try the following methods to recover:
1. Close and reopen Excel: Sometimes Excel will close after closing. to automatically save changes, try reopening Excel to see if you can revert to the pre vious version.
2. Use the version history function: If you are using Office365, you can use the version history function to view and restore pre vious versions. The steps are: click "File" > "Information" > "View Version History" and then select the version you want to restore.
3. Check the temporary file: Excel will create a temporary file when it is closed. This file may remain in the C:\Users\your username\AppData\Local\Microsoft\Office\UnsavedFiles folder. You can try to find and recover files in this folder.
4. Use third-party software: Third-party software such as Recuva and EaseUSDataRecoveryWizard can help recover Excel files.