Password Encryption option greyed out

Justplainj

New Member
Joined
Apr 15, 2021
Messages
30
Office Version
  1. 365
Platform
  1. Windows
Good day,

I am using MS Office 365 updated to the most recent version.
I was sent an email with an excel attachment and I am able to open it without requiring any password via the password encryption feature via File>Info>Protect Workbook>Encrypt with Password function.
It is also not password protected via the Review tab on the Ribbon.

However, after I added additional information I wanted to encrypt it with a password via the File>Info>Protect Workbook>Encrypt with Password function but am unable to do so because it is greyed out along with all other options in this submenu other than Restrict Access.

I have tested several other excel sheets both which I created and which was sent to me in the past and also tested it by having the original author create a new workbook, password encrypt it and then send it to me via email and I am able to open it and remove/change the password encryption, etc.

This workbook in question is greyed out for the author as well.

It is only this workbook which is affected by this problem so am quite sure it is not a registry issue which is the most common problem/solution that comes up when I google this issue.

If anyone has an idea why this is happening please let me know.

Thank you,
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,255
Messages
5,836,274
Members
430,414
Latest member
ayla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top