Win7 system Excel2010 How to save and recover data periodically

Win7 system Excel2010 How to save and recover data periodically

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.

Windows7 Tutorial

WINDOWS8 Tutorial

WINDOWS10 Tutorial