Question / Excel / Protect Sheet Option

%3CLINGO-SUB%20id%3D%22lingo-sub-2728801%22%20slang%3D%22en-US%22%3EQuestion%20%2F%20Excel%20%2F%20Protect%20Sheet%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2728801%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20created%20an%20excel%20sheet%2C%20clicked%20protect%20sheet%20with%20password%20added%2C%20how%20come%20when%20others%20sent%20the%20excel%20sheet%20back%20to%20me%2C%20the%20%22protect%20sheet%22%20option%20is%20no%20longer%20there%3F%20It's%20as%20the%20sheet%20was%20never%20protected%20in%20the%20first%20place.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anything%20I%20can%20do%20to%20prevent%20others%20from%20unlocking%20my%20sheet%20without%20password%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*Excel%20version%202016%20%2F%20Windows%2010*%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2728801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2728822%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20%2F%20Excel%20%2F%20Protect%20Sheet%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2728822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1148882%22%20target%3D%22_blank%22%3E%40Carol969%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Excel%20password%20protection%20is%20mainly%20to%20protect%20from%20people%20negligence.%20Such%20protection%20is%20relatively%20easy%20to%20remove.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20740px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308544iAF19BE85A4FAE86E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprotection-and-security-in-excel-be0b34db-8cb6-44dd-a673-0b3e3475ac2d%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EProtection%20and%20security%20in%20Excel%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2728857%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20%2F%20Excel%20%2F%20Protect%20Sheet%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2728857%22%20slang%3D%22en-US%22%3EThank%20you%20Sergei.%3CBR%20%2F%3ESo%20there%20is%20no%20possible%20way%20for%20me%20to%20prevent%20others%20from%20unlocking%20my%20excel%20sheet%20and%20adjust%2Fremove%20my%20formula%3F%3C%2FLINGO-BODY%3E
New Contributor

Good morning everyone,

 

If I created an excel sheet, clicked protect sheet with password added, how come when others sent the excel sheet back to me, the "protect sheet" option is no longer there? It's as the sheet was never protected in the first place.

 

Is there anything I can do to prevent others from unlocking my sheet without password?

 

Thank you

 

*Excel version 2016 / Windows 10*

 

3 Replies

@Carol969 

In Excel password protection is mainly to protect from people negligence. Such protection is relatively easy to remove.

image.png

Protection and security in Excel (microsoft.com)

Thank you Sergei.
So there is no possible way for me to prevent others from unlocking my excel sheet and adjust/remove my formula?

@Carol969 

I think so, if the person has enough skills (s)he could remove the protection. Yu may try yourself, the easiest way - upload protected file to Google Sheets and download it back as Excel file. Most probably protection will be lost. You may corrupt the file by such way, depends on formulae used, but there are other ways.