Friday, May 27, 2011

How to Recover Deleted Excel Files


Enable Automatic Recovery and Saving
1. Open Excel and select 'File,' 'Help,' and then 'Options.'
2. Select 'Save' and set the number of minutes between automatic saves in the provided check box.
3. Check the box to 'Keep the last autosaved version if I close without saving' if it is not already checked.
Recover Earlier Versions of an Excel Worksheet
4. Open Excel and select 'File.' If you are recovering an existing worksheet, select 'File,' and then 'Open' to select that worksheet.
5. Select 'Recent' to recover a brand-new file that you have not yet saved. Select 'Info' to recover an existing worksheet.
6. Select 'Recover Unsaved Workbooks' to recover the new worksheet. For existing worksheets, select 'Versions.'
7. For new worksheets, select the draft from the pop-up windows that appears. For existing worksheets, select the version that lists 'when I closed without saving,' and then click 'Restore' to make this version the one that is current. This overwrites any changes in the opened file to the last automatically saved content in the worksheet.
8. Select 'File,' and then 'Save' to avoid any further data loss.
Use Document Recovery
9. Recover your worksheet from the Document Recovery pane appears, which appears if you haven't enabled the auto-save feature in your Microsoft Office products.
10. Click the arrow next to the worksheet you need to recover. Select 'Open' to view the recovered worksheet; select 'Save As' to open the worksheet and create a fresh version and select 'Delete' if you don't need the recovered version.
11. Select 'File,' 'Save' to avoid any further data loss.

Blogger news