Win7 system Excel2010 timing save and data recovery

When you use Excel to do a lot of data tables, the computer suddenly crashes and restarts. At this time, do you still have to crash? Now you can restore the data by opening the Excel2010 timed save function. Don't worry about the computer crashing and restarting.

1. We open the excel document, click on the “File” option in the upper left corner;

Excel file options

2. Click on the “Files” menu. <;Options" button;

File Options

3, then click on the “Save” option in the pop-up dialog box and find the “Save Time Interval” setting. Option, modify the save interval;

save interval

4, and when we need to restore the data, usually when the document is reopened, the document will automatically remind whether to open the shutdown For the previously retained documents, we can click to select;

Data Recovery

5. We can also click on <;File” Options;

Restore Data

6. Select the “Manage Version” in the “Information” option and return to the saved worksheet. Select the version you want to restore in the pop-up dialog box;

Revert to saved worksheet

7. We can also click &ldquo The recently opened document ” option, where you can find the "Restore unsaved workbook" option, click OK to restore the required version data.