web analytics

USING THE AUTO RECOVER FEATURE IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article will show you how to use the document recovery feature that Microsoft Excel 2013 offers in case your computer crashes. This auto recover feature will save all of your workbooks at automatically set regular intervals. If a computer crash occurs, Microsoft Excel 2013 will display a recovery task pane of your document when you launch your Microsoft Excel 2013 workbook again after you reboot your computer.

1

This is very important because this feature will only work if on your Microsoft Excel 2013 workbooks that you have previously saved. If you haven’t saved the Microsoft Excel 2013 workbook you have worked on and a computer crash occurs, the auto recover feature will not work and there won’t be a saved copy.

When you start using Microsoft Excel 2013 for the first time, the auto recover feature is set to automatically save changes to your workbook every ten minutes. If you have already saved your Excel workbook, then you can also change the interval of automatic saving if you choose file options, save to open the Excel options dialog box with the saved document selected. Then you should use the spinner buttons or you can also enter a new automatic save interval into the text box marked save ought to recover information every ten minutes. After that you should click the OK button

2

When you rebooting after a computer crashed the program opens with the document recovery notification click this show a recovered files button to reveal the recovery task pane on the left side of the screen. The pane will show all the available versions of your workbook files that were open at the time when your computer crashed.

3

The original version of the workbook file is identified including when it was saved as is the recovered version of the file and when it was safe to open the recovered version of a workbook position the mouse pointer over the auto recover to show. Click its drop-down menu button, followed by open. You can choose to save its changes by clicking on the save button located on the quick access bar or by clicking File Safe in order to save the recovered version of an Excel workbook without bothering to first open it click the recovered versions drop-down button in the document recovery task pane and then choose Save As.

4

If you only want to have the original version of the document and to close the recovered version, you should click on the close button located at the bottom of the document recovery task pane. After you do this an alert dialog box will appear and it will give you the option to keep the recovered versions for later viewing. If you want to save the files for later viewing select the YES button before clicking on the OK button. In order only to retain the original of your Excel workbooks that are shown in the task pane, select the NO button.

Leave a Reply