How do I remove "Book1.xlsx is protected" when opening a file

1

I have a file for which I get asked for a password when I try to open it. I know this password:

enter image description here

I want to remove the protection from the workbook, and assumed I could do this by going to File > Info > Protect Workbook, but when I do this the option for password protecting the file is greyed out, and there is no option for removing the password protection.

enter image description here

So can someone please tell me how I remove the password protection from the workbook?

eirikdaude

Posted 2019-12-04T09:49:14.073

Reputation: 821

In the Review tab, group Protect, do you have any "Unprotect" button? If you do, press it, enter password, and OK. – harrymc – 2019-12-04T10:21:50.203

@harrymc I'm afraid not – eirikdaude – 2019-12-04T10:28:09.540

Answers

2

Go to file -> Save As

Select Tools -> General Options

(See image)

enter image description here

Clear out the Password to open.

enter image description here

Hit OK, then Save the spreadsheet.

You can also follow these instruction to put the password back in place.

PeterH

Posted 2019-12-04T09:49:14.073

Reputation: 5 346

That did it, thanks – eirikdaude – 2019-12-04T10:33:35.567

Asked: 2019-12-04T09:49:14.073

Viewed: 64 times

Active: 2019-12-04T10:30:59.443