Pls provide soulution i am working with excel 2007 so we want to use pivot option in this pls help

Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password
Set a password to open Excel 2007

• 1. Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document
• 
  
• 2. In the Password box, type a password, and then click OK.
• You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
• 3. In the Reenter password box, type the password again, and then click OK.
• 4. To save the password, save the file.

Set a password to modify a Excel 2007 Spreadsheet

• In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
• 1. Click the Microsoft Office Button , click Save As, and on the bottom of the Save As dialog, click Tools.
• 2. On the Tools menu, click General Options. The General Options dialog opens.
• 3. Under File sharing, in the Password to modify box, type a password.
• 4. In the Confirm Password dialog, re-type the password. Click OK.
• 5. Click Save.

Remove password protection from an Excel spreadsheet

• 1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
• 2. Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document.
• 
  
• 3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  
• 4. Save the spreadsheet.
  

Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007

Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007

1. Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document.
2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
   
3. In the Reenter password box, type the password again, and then click OK.
4. To save the password, save the file.

Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.

1. Click the Microsoft Office Button , click Save As, and on the bottom of the Save As dialog, click Tools.
2. On the Tools menu, click General Options. The General Options dialog opens.
3. Under File sharing, in the Password to modify box, type a password.
4. In the Confirm Password dialog, re-type the password. Click OK.
5. Click Save.

Remove password protection from an Excel spreadsheet

1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
2. Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document.
   
   
   
   
3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
4. Save the spreadsheet.

Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?