Win7 system Excel2010 Timing Save and data recovery

When you use Excel hard to do a lot of data tables, the computer suddenly crashed and restarted, this time you are also going to crash it? Now just open the Excel2010 timer save function can restore the data, and do not worry about the computer crash restart.

1, we open the Excel document, click on the upper left corner of the "file" option;

Excel file Options

2, click on the "File" menu under the "Options" button;

File options

3, then in the pop-up dialog box, select the "Save" option, and find the "Save Interval" setting options, modify the Save interval time;

Save time interval

4, and when we need to restore the data, usually when the document is reopened, the document will automatically remind you to open the left before the shutdown of the document, we click on the selection is available;

Data recovery

5, we can also click the "File" option;

Recover data

6, select the "Information" option "Management version"-"Restore to save the worksheet", in the pop-up dialog box to select the version you need to restore;

Revert to saved worksheet

7, we can also click the "recently opened documents" option, find the "Restore unsaved Workbooks" option, click OK, restore the required version data.