Microsoft Office, Tools, Recovery -Recent updates seem to hav stopped my Excel from recognising saved spreadsheets.

There are many people out there who are looking for great open source software, and some of you have stumbled upon Open Office or Libre Office. This is a great alternative to Microsoft Office but with one small problem. It is always trying to get you to save in the Open Document format instead of a Microsoft Office format that your friends and coworkers can open and use. Well I am going to show you a solution to this problem!

Open up any of the programs in the Open/Libre Office suite. Once it is open go into the Tools menu and select "options". From there, expand the Load/Save option and then select "general"



Near the bottom you will see a heading for "Document Type". Select the dropdown box under that and select "Text Document" and then select the dropdown box under "Always Save as" and then select "Microsoft Word 97/2000/XP". After that go back to the "Document Type" and select "Spreadsheet" and set always save to "Microsoft Excel 97/2000/XP". Lastly Choose "Presentation" and always save as "Microsoft PowerPoint 97/2000/XP". Once you do this hit "OK" and your changes will be saved. From now on everytime you save a Word document, an Excel spreadsheet or a PowerPoint presentation it will by default save as a Microsoft Office format!

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?