Recovering Lost Data On Excel

Microsoft Excel is an excellent tool to create tabulated data and present it in an orderly fashion. The data is entered into spreadsheets that can be manipulated and customized in any fashion. In computing terms, a "spreadsheet" is a type of large table that is used to display information. It is important to save your data during every stage of your spreadsheet; however, there are cases when users are unable to save any current data before an unfortunate shut down of the computer. Luckily, Microsoft Excel 2007 has an AutoRecover option, which saves early versions of your worksheet. The Document Recovery feature may display the saved worksheet saved in one to three files. The most recent data will be lost but your worksheet will retain its format and data up to the previous save.

Here are a couple of suggestions you can employ to reduce any further losses in data, and not have to worry about saving each time:

Instructions to Activate the AutoRecover Option

  • Launch Microsoft Excel 2007 and open the worksheet.
  • Click on the Microsoft Office button on the top left of your screen. A drop down menu will appear.
  • Select the Excel Options button, which is situated at the bottom of this menu. This opens a dialog window for Excel Option.
  • On the left pane of the window select the Save option. A dialog window for Save Workbooks will appear.
  • Check the Save AutoRecover Information Every [ ] Minutes. In this, you can select the number of minutes after which any changes will be automatically saved.
  • Click Ok.

Using the Document Recovery Pane

  • Open the worksheet. On the left side of the document, the Document Recovery task pane will open, displaying one to three versions of your Excel worksheet.
  • Right click on any version. A list will open up displaying the following commands: Open, Save As and Delete. Open lets you view this recovered sheet, Save As will let you rename or start a new version of the sheet, and Delete will delete that worksheet.
  • Click on Open or Save As for the version you wish to revise or save.
  • Save this worksheet.

If you still encounter difficulties in saving sheets, you can contact Excel Tech support for further clarification. Excel tech support provides good customer care, and you can enquire about other features of Microsoft Excel 2007. All other issues and problems can also be solved by contacting them, or checking up on the internet in forums and discussions.
Share on Google Plus

About Admin

    Blogger Comment
    Facebook Comment


Post a Comment