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.
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.
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.
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."
Tips & Warnings
- 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.
How to Use an Open Office Spreadsheet
Open Office is a free, full-featured open-source office suite software program. You can use OpenOffice.org Calc to create your own spreadsheets and...
How to Remove a Password Protected Cell
Microsoft Excel is a powerful program that can be used like a very simple database or list of information or used to...
How to Remove a Password in Office Excel 2007
Microsoft Excel documents are used to store assorted types of data, with assorted levels of importance. If a particular set of data...
How to Remove the Password Required to Open Excel
Microsoft Excel lets you create and organize household budgets and customer invoices, and makes it possible to quickly perform tasks like balancing...