Security conscious people usually set passwords to encrypt Office files that contain critical data. However, it will cause you to be unable to open or modify an Office document if you forget or lose the password. Then what can you do when forgot password to open or modify Office document? Now this page will give solutions based on the two cases.

Case 1: What if you forgot password to open Office document

There are two solutions.

Solution 1: Retrieve forgotten password

Microsoft always caution that if you lose or forget the password, it cannot be recovered. But a specialized Office Password Recovery tool like Office Password Refixer can help you retrieve a forgotten Office document open password with ease.

Solution 2: Remove forgotten password

If your Office document is saved as the older (97-2003) format such as .doc, .xls, .ppt, you can use one Office Password Remover tool to remove the forgotten Office password online so that you can open the document without password.

Case 2: What if you forgot password to modify Office document

When an Office Word document is restricted editing with password, or when an Excel sheet is protected with password, you won’t be able to edit the word or modify the sheet once password is forgotten or lost. Luckily, you can remove the forgotten password to modify an Office document by using 7-zip. Steps are as follows.

Step 1: Make sure the Office file is saved as the latest .docx/.xlsx format. If not, open it and then save it as the new format.

Step 2: Change the Office file name extension from .docx/.xlsx to .zip.

Step 3: Open the .zip archive.

Step 4: Delete the documentprotection or sheetprotection element.
1. For Word document, open the folder word, and then open the settings.xml file with Notepad. In the notepad, press Ctrl + F to bring up Find dialog, then type documentprotection and click Find Next. Once it finds the documentProtection, delete the entire element beginning with w:documentProtection, including the < and >, and then press Ctrl + S to save the changes. Close the settings.xml file and update it in the .zip archive when prompted. Then the forgotten password that restricts editing can be removed.

delete documentprotection element

2. For Excel document, go to the folder xl -> worksheets. Then select the sheet.xml and open it with Notepad. In the notepad, find sheetprotection and delete the entire element. Save and close the sheet.xml file and update it in the .zip archive. Then the forgotten password that protects the sheet can be removed.

delete sheetprotection element

Step 5: Change the file name extension back to .docx/.xlsx from .zip. Then you can edit or modify the Office document without password required.