Protected Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2271077%22%20slang%3D%22en-US%22%3EProtected%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2271077%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20evening%20folks%2C%3C%2FP%3E%3CP%3ENew%20here%2C%20I%20would%20like%20some%20assistance%20in%20determining%20how%20I%20can%20remove%20the%20protection%20on%20a%20workbook%20that%20I%20placed%20by%20mistake.%26nbsp%3B%26nbsp%3B%20Any%20assistance%20would%20be%20greatly%20appreciated.%26nbsp%3B%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2271077%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Good evening folks,

New here, I would like some assistance in determining how I can remove the protection on a workbook that I placed by mistake.   Any assistance would be greatly appreciated.   Thanks.

2 Replies

@bcnew175 

If without VBA within the workbook, try to upload on Google sheets and when download back as Excel workbook. Quite often that works.

@bcnew175 

There are several methods of opening a file. One is secured that Mr. Baklan has already posted to you.

Here are two more methods.

If you still cannot open the file, send it to me via private message and depending on the file I will try to help you ... only Mr. Baklan's method and mine do not work.

 

Method 1:

Change the Excel file to a ZIP folder. That's how it's done:

Right click on the Excel file, click on Rename, delete the text "xlsx" at the end of the file name and type in zip. Make sure you keep the period between the filename and "zip". Press ↵ Enter, then press Yes.

 

Extract the ZIP folder (varies by operating system): Right-click the ZIP folder, click Extract all in the drop-down menu, then click Extract. The extracted folder should open.

If for some reason the extracted folder didn't open, first double-click the normal folder with the same name as the ZIP folder.

 

Method 2:

Click with the right mouse button on the sheet whose protection you want to remove (e.g. "Sheet1"), go to Open with in the drop-down menu and click on Notepad in the pop-out that appears.

 

Remove the password protection code. Find the area "sheetProtection" between the brackets "<>", then delete everything from "<sheetProtection" to the closing bracket ("/>") on the other side of the sheet protection algorithm.

Save your changes and close the text editor.

 

Open your Excel sheet. Double-click the Excel sheet, then edit it as needed.

 

If you get an error message that the Excel spreadsheet is damaged, you probably deleted additional code when you tried to remove the password protection algorithm. Repeat the steps above, making sure that you only remove the text between the brackets (</>) and the brackets themselves.

 

If that doesn't help, as I said ... by private message.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)