We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Use OpenOffice to Remove Protection From Excel

Updated April 17, 2017

A Microsoft Excel document saved in a version of Microsoft earlier than 2007 could automatically lose its password when opened in OpenOffice Calc. If you're trying to remove the password or other protection from an Excel document with OpenOffice Calc from a 2007 or later version, however, it becomes a little tricky. But there are a couple options you can take to remove protection from an Excel document, making it so that anybody can use it.

Loading ...
  1. Open the document by double-clicking on the icon on the desktop or in the appropriate folder. If it prompts you for a password, enter it.

  2. Click "File" and "Save As." Choose the option that saves the file with the ".xlt" extension. Uncheck the option in the bottom left corner that says "Save with password." Press "Save." This removes the password protection.

  3. Click the "Tools" menu and choose "Protect Document." Either the "Sheet" or "Document" option may have a checkmark next to it. Uncheck it. You may need to enter the password. This will unprotect the entire document. Verify this by typing in one of the cells. If you can type in the cells, they are unprotected. Save by pressing "Ctrl+s."

  4. Warning

    If you don't know the password, you cannot open the document or remove it. You'll need to buy a special program to remove the password.

Loading ...

About the Author

Colby Stream has been a writer since 2007. His work has appeared in "The Arbiter," the student newspaper of Boise State University, as well as various websites. Stream graduated with a Bachelor of Arts in communication as a presidential civic leadership scholar.

Loading ...