Please back up your Excel worksheet first in case of data loss.
Go to Google Sheet and start with a blank spreadsheet.
Navigate to File>Import.
Go to “Upload” tab.
Drag your password-protected worksheet to Google sheet.
Press “Import Data” button to continue.
Locate your password-protected Excel worksheet and change its file extension to zip.
Open the zip archive and go to xl>worksheet.
Right click on the locked sheet. Select “Edit” to open it in Notepad.
Press Ctrl+F to find sheetProtection and delete the whole string.
Now, update the modified xml file.
Change the file extension back to xlsx.
Locate your password-protected Excel worksheet and open it with Microsoft Excel.
Press Alt+F11 to bring out the Visual Basic screen.
Navigate to Insert>Module.
Now, insert the VBA code to it.
Press F5 to run the code.
Download, install and run Passper for Excel on your PC.
Choose “Remove Restrictions” on the main interface.
Click “Select a file” to import your locked Excel sheet.
Click on the “Remove” button to begin the removal process.