How to Unprotect Excel Workbook without Password (3 Easy Methods)


Method 1 – Remove Password to Unprotect Excel Workbook

Here we have a password-protected Excel worksheet.

Remove Password to Unprotect Excel Workbook 

 

Remove Password to Unprotect Excel Workbook 

Steps:

  • Right-click on the Excel file and select the Rename option.

  • Add the .zip extension after removing the .xlsx Press Enter.

Remove Password to Unprotect Excel Workbook 

  • Open the zipped folder by double-clicking it, and then open the xl folder.

  • Open the worksheets folder in the xl folder.

Remove Password to Unprotect Excel Workbook 

  • Right-click the sheet1.xml file or press Ctrl+C’ on the keyboard to copy it.

  • Use Ctrl+V’ to paste it into your required folder.

Remove Password to Unprotect Excel Workbook 

  • Open sheet1.xml in notepad.

Remove Password to Unprotect Excel Workbook 

  • Open the Find search box by pressing ‘Ctrl+F’.
  • In the Find what box, type protection.
  • Press Enter to find the word.

Remove Password to Unprotect Excel Workbook 

  • Select the “sheetProtection” tag.

  • Drag the mouse to the right until you come to the end of the “/>” tag.

Remove Password to Unprotect Excel Workbook 

  • Remove the selected line from the code, then save it with Ctrl+S’.

  • Press ‘Ctrl+C’ to copy the modified file.

Remove Password to Unprotect Excel Workbook 

  • With the Copy and Replace option, paste this file to its original destination.

Remove Password to Unprotect Excel Workbook 

  • Rename the zip folder. To turn it back into an Excel file, remove the .zip extension and add the .xlsx extension.

  • Open the file and click to allow it to be viewed without a password.

Remove Password to Unprotect Excel Workbook 


Method 2 – Utilizing Google Sheets to Unprotect Excel Workbook without Password

 

Steps:

  • In your browser, open a new Google Sheet by clicking on Blank.

Utilizing the Google Sheets to Unprotect Excel Workbook without Password

  • Click on the Import option from the File menu.

Utilizing the Google Sheets to Unprotect Excel Workbook without Password

  • Select the Upload option and click on “Select a file from your device”.

  • Select the file and click on Open.

Utilizing the Google Sheets to Unprotect Excel Workbook without Password

  • Click on Import data.

  • You will be able to import your excel file into Google Sheets.

  • Go to the File menu, select Download, and choose Microsoft Excel(.xlsx).

Utilizing the Google Sheets to Unprotect Excel Workbook without Password

  • Save the file to your desired location and rename it.

Utilizing the Google Sheets to Unprotect Excel Workbook without Password

  • Open the file and click to allow it to be viewed without a password.

Utilizing the Google Sheets to Unprotect Excel Workbook without Password


Method 3 – Unprotect Workbook by Copying Contents to a New Workbook

Steps:

  • Select the protected sheet in the protected workbook.
  • Press Ctrl+C’ or right-click the mouse to copy the worksheet.

Unprotect Workbook by Copying the contents to a New Worksheet in Excel

  •  In a new workbook paste it by pressing Ctrl+V’.

  • Open the file.

Unprotect Workbook by Copying the contents to a New Worksheet in Excel


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Related Articles


<< Go Back to  Unprotect Workbook in Excel | How to Unprotect in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo