How to Remove Password Protection in your MS Excel Worksheet

It is a good idea to protect your important file for security. But sometimes, we tend to forget these passwords because there are so many of them. If you forgot your password in your MS Excel sheet, worry no more because you can still use and modify its content by following this tutorial.

In this tutorial, we need the following:
  1. Your MS Excel File

  2. WinRAR app

    WinRAR is a trialware file archiver utility for Windows, created by Eugene Roshal of win.rar GmbH. It can make and view archives in RAR or ZIP file formats, and unpack or decompress several archive files formats. WinRAR is circulated as "try before you buy"; it can be utilized without charge for several days. When the trial period ends, the non-enterprise functionalities can still be used, a move meant to discourage piracy. Search WinRAR, then install the trial version, if you do not have one installed on your PC.

  3. Notepad

    It is a simple text editor for Microsoft Windows and a basic text-editing application that allows computer operators to make documents. It was first distributed as a mouse-based MS-DOS program in 1983 and has been incorporated in all editions of Microsoft Windows since Windows 1.0 in 1985.





Steps in removing the password protection in your MS Excel Worksheet:
  1. Open the location of the MS Excel file that you would like to remove the password protection.Remove Password Protection in your MS Excel Worksheet
  2. Make sure that that "file name extensions" is enabled. To enable this, in your windows explorer, click on the VIEW menu, see the picture.
    Remove Password Protection in your MS Excel Worksheet

  3. Then bring your mouse to "file name extensions", see the picture.
    Remove Password Protection in your MS Excel Worksheet





  4. Then enable it, check the picture.
  5. Your MS Excel file will now have "file extension" next to the file name, see the picture.
    Remove Password Protection in your MS Excel Worksheet

  6. Rename your MS Excel File (from MS File.xlsx to MS File.zip). A rename prompt will show, just click YES.
    Remove Password Protection in your MS Excel Worksheet
    Remove Password Protection in your MS Excel Worksheet
  7. The new file icon will look like this.
    Remove Password Protection in your MS Excel Worksheet

  8. Right-click the file and select "open with WinRAR."
    Remove Password Protection in your MS Excel Worksheet

  9. A new dialog box will appear, just follow the instruction.
  10. Open the "xl" folder, see the picture.
    Remove Password Protection in your MS Excel Worksheet
  11. ... then the "worksheets" folder.
    Remove Password Protection in your MS Excel Worksheet
  12. Then you will see all the sheets available in the MS Excel File. Since we only have 1 worksheet in the workbook, you will only see 1 file in the "worksheets" folder.
    Remove Password Protection in your MS Excel Worksheet





  13. Move the "sheet1.xml" to a folder where your file is located (You may also use the COPY-PASTE method).
    Remove Password Protection in your MS Excel Worksheet
  14. Open the "sheet1.xml" that you moved in its new location with the Notepad. Right-click -> Open with -> Notepad
    Remove Password Protection in your MS Excel Worksheet

  15. XML code of sheet1.xml will appear.
    Remove Password Protection in your MS Excel Worksheet

  16. Press CTRL+F on your keyboard, to enable the "find" dialog box.
    Remove Password Protection in your MS Excel Worksheet

  17. On the "find what" box key-in "protection" then hit the "find next" button. This will find and show the word "protection" in the file.
    Remove Password Protection in your MS Excel Worksheet

  18. Select then delete the code that starts with "<" and ends with "/>" where the keyword "protection" is included. See the picture.
    Remove Password Protection in your MS Excel Worksheet

  19. Close, then SAVE the file.
    Remove Password Protection in your MS Excel Worksheet





  20. Open the WinRAR App, then move back the "sheet1.xml" file to its original location (You may also use the COPY and PASTE method).
    Remove Password Protection in your MS Excel Worksheet

  21. A new dialog box will appear, just click OK then close the WinRAR window.
  22. Rename your file from "MS File.zip" to "MS File.xlsx".
  23. Password protection has been now removed. You can now modify or edit your worksheet.
  24. If you have multiple worksheets, you need to do those steps for every "sheet.xml" that you have starting from step 12.
Leave us a comment if you encounter a problem.

Comments

The Author

Gelo is a tech and gadget enthusiast who spends his day blogging, watching videos online, and reading ebooks.      Search