Wednesday, February 22, 2012

How to Recover MS Excel Files After Closing


Enable AutoRecover
1. Open the Excel program. A new worksheet appears.
2. Click the 'File' tab. A list of basic commands appears.
3. Click 'Options' under 'Help.'
4. Click 'Save.' A dialog box opens.
5. Select the check box for 'Save AutoRecover Information Every X Minutes.'
6. Type the number of minutes, such as every 10 minutes, for the frequency of saves.
7. Select the check box for 'Keep the Last Autosaved Version if I Close Without Saving.' The Excel files will save at least one version.
View the Document Recovery Pane
8. Open the Excel file. A Document Recovery task pane opens next to the worksheet.
9. Click the arrow next to the recovered file icon in the 'Available Files' text box. A list of options appears: 'Open,' 'Save As' or 'Delete.'
10. Click 'Open' to review the version of the file. Click 'Save As' to rename and create a new copy of the workbook. Click 'Delete' to delete this version.

Blogger news