Retrieve Lost Excel 2007 Document From An Unsaved Worksheet

There could be scenarios where due to an abrupt restart of your PC or other reasons, you would lose the Excel file that you were currently working on. So in order to save your effort, there is a wonderful tool available inside MS Excel 2007, which will automatically keep saving your Excel sheet by creating restore points at regular intervals of time. 

In this section, we will be dealing with certain Excel tech support guidelines to use the Document Recovery Pane as well as to activate the AutoRecover option so that you won’t lose your important documents anymore.

Activate AutoRecover option

• First, launch the Microsoft Excel application from the Windows Start menu option.
• Locate the Microsoft Office button towards the top left of the screen and click on it to open up the drop down menu.
• Now open the dialog window for Excel Options by clicking the Excel Options button located at the bottom of the drop down menu.
• Navigate to the left pane and click on the Save link, which in turn will open up a dialog window for Save Workbooks.
• Enable Save AutoRecover Information Every [ ] Minutes by marking the check box adjacent to it. Also, enter the number of minutes in order to set the time interval at which you require the AutoRecover function to happen. Finally click OK button to save your settings.

Using Document Recovery pane

• Launch the Microsoft Excel application. You will receive the Document Recovery task pane over the left pane of the application window. You will probably receive various versions of your Excel worksheet.
• Choose the appropriate one, right click on it and select any of the three options, which are Open, Save As and Delete. Choose Open command if you require to review your document before saving it. Choose the Save As command if you want to rename the documents or save the file in a different location. Finally select Delete command, if you want to delete the document. 
• You need to choose Open or Save As to recover the version of your Excel document.

We hope you are clear with the instructions to retrieve a lost Excel 2007 document from an unsaved worksheet. If you have any further doubts on this, contact the Excel tech support team and get your problem fixed quickly.