Repair the Damaged Excel File

Microsoft Excel is the most commonly used spreadsheet application among home users and financial experts. The file you create in MS Excel is saved in .xls or .xlsx format depending on the MS Excel version using which the file is created. If you create the file in Excel versions up to Excel 2003 then the file will be saved in .xls format. And if the file is created in Excel 2007 then the file extension will be .xlsx. However, the file can be corrupted anytime due to abrupt system shutdown. Sometimes, due to sudden system shutdown, header structure of the file gets damaged leading in MS Excel to display an error message. The error message indicates the file corruption due to which MS Excel cannot open the file.
It may happen that the file contains lots of valuable data that you can never think to loss and losing that data means a big loss. But, you don't need to worry because in this article you will know a simple process to recover data from the damaged Excel file. Execute the following steps to repair the damaged Excel file:

1. Navigate to the folder where the damaged Excel file is available. The damaged file can be identified by its name as the name of damaged Excel file gets changed to some alphabetical name like BD45SD, DB2548O, etc.
2. Right-click the damaged file and select the Rename option.
3. Rename the file with a desired name following by .xls extension or with .xlsx extension. If the file was created using Excel version lower than Excel 2007 then rename the file with .xls extension else rename the file with .xlsx extension.

The file appears in Excel format. Now, you can open the file to continue your work. This is how you can recover data from Excel file, which has been damaged due to sudden power outage or abrupt system shutdown.

Password Protect Word 2007 - Excel 2007 Documents

When you work on a shared computer i.e. a computer that multiple users use then you should protect your documents with a password. This is because if any intruder accesses your valuable document, s/he can delete the content, modify the content, or steal information. In this article, you acknowledge protecting Word and Excel documents in Office 2007. Whenever you protect any document, always try to use typical password so that no one can easily break it. Always use alphanumeric password for protecting your documents. In MS Office 2007, you can specify password either to protect the document from being opened by any other person or to protect the document from being modified or for both. Let us execute the following steps to protect a Word 2007 or Excel 2007 document:

1. Click the Office button after you have created the document.

2. Select Save As option. The Save As window appears.

3. Click the down-down arrow in Tools button on left bottom of Save As window and select the General Options, as shown in following figure:

4. Specify password in the Password to open text box to protect the document from being opened.

5. Specify password in the Password to modify text box to protect the document from being modified.

6. Select the Read-only recommended check-box.
7. Click the OK button:

The Confirm Password window appears. This Confirm Password window appears twice if you have specified password in both Password to open and Password to modify text boxes otherwise appears only once.

8. Re-enter password and click the OK button:

9. Now, save the document at desired location on your computer system.

In this way, you can provide security to Word 2007 or Excel 2007 documents and stop others poking inside your documents.