excel made a mistake and saved it, how to restore it to the document before saving

1. Prepare simulation data. Feel free to type something like 1, 2, 3, 4, 5, 6

2. Find the "File Round Button in the upper left corner" in the menu bar.

3. Click on the options in the left box.

4. In the pop-up "Excel Options" window, click the "Save" button and set the "Save Auto-Recovery Information Interval of 10 Minutes" to 1 minute.

5. After setting, modify the content in **, change the font color to "orange", save and wait for 2 minutes, and then start to retrieve the original version.

6. Go to the place where you set the auto-save interval, find the save path, and the general address is "C: Users [local account name] AppData Roaming Microsoft Excel". You can see that at the bottom of the folder, there is a folder named after the current excel file name.

7. Enter the folder, there may be one or more saved documents in it, click on any document, and you can view the previous archive files.

8. After double-clicking any file to open it, you can see that there is a horizontal bar below the toolbar showing whether it is "restored", and we will restore it according to the situation.

I can't find any of them. Wish you good luck: DocumentsAndSettings Microsoft if you're lucky; Your computer login name is more troublesome; applicationdata, think about whether you sent this file to others before modifying it; Excel, there is something you can find before.

If it doesn't work, then you want a copy back, you need to get it again, first go to the default autosave directory of excel to see it, c

First of all, go to the default autosave directory of excel, C: documentsandsettings Your computer login name ApplicationData Microsoft Excel If you're lucky, you can find the previous one.

I can't find it on it, so it's more troublesome and I need to get it again. Hope you are in good luck.

1. First open the Excel on the computer, and then click on the file in the upper left corner, as shown in the figure below.

2. In the pop-up interface, select the information, and then click Manage Version, as shown in the figure below.

3. In the pop-up interface, click Recover Unsaved Workbook, as shown in the figure below.

4. In the pop-up interface, find the unsaved workbook and click to select it, as shown in the figure below.

5. After that, click the drop-down arrow on the side of the open, the pop-up interface, click to open and repair.

If Excel is not closed after saving, you can use the undo button or Ctrl+Z to undo the changes;

If you save it and close it, there's no way to recover it.

Excel has the function to undo an action, and you can revert to the previous situation if you made a mistake and saved it in Excel.

1. First click to open ecxel**, enter ecxel**, and click on the file option above.

2. Scroll down on the left page and find the Manage Versions option. Select a version of the last saved file and double-click the left mouse button.

3. After finding it, click on the title, and then double-click the left mouse button, so that the ** before this unmodified copy is opened.

4. Then click on the file option above the document, save this ** selection as, and save it to your computer.

Operating computer: Lenovo G480

Operating system: Windows 8

Excel has saved the way to restore to the original state after modification, as follows:

1. First of all, open the excel file you need.

2. Enter the interface and click "File" in the upper left corner.

3. Click the "Options" button on the left.

4. The excel options page pops up, click "Save", and set "Save Auto-reply Message Time Between Filial Piety and Caution and Patience" to "1 minute".

5. Modify the content in the source file and wait for more than one minute after the modification is completed.

6. Find the "Auto-reply file location" on the excel option page just now.

7. In this location, you can find the saved files, and you can see the restore after double-clicking. <>

1. First of all, prepare the Excel file you need to recover, this file is the original file.

2. Open the excel file, then find and click on the file option in the upper left corner.

3. Find the option button at the bottom of the pop-up window on the left, and click Options.

4. After clicking, the excel options page will appear, click the save option, and set the interval for saving the auto-reply message to 1 minute.

5. Then modify the information in the source file, and wait for more than a minute after the modification is completed.

6. Then find the path position in the save button of the excel options page just now.

7. After finding this location, we can see a lot of saved files.

8. After double-clicking, you can see the restoration, and click to restore the previous document.

Here's how to fix it:

1. First of all, we open the excel** in the computer and click on the "File" option;

2. Then right-click and select "Save As", and then select the disk you want to save according to your needs.

3. In the pop-up prompt bar, click the "Tools" button;

4. Then select "General Options" and click to enter;

5. Then select "Generate Backup File" and click OK;

6. Then you can see that there is a file with the same name in the directory, and this backup file is the ** data before the modification that we want to recover.