Protect function not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1828316%22%20slang%3D%22en-US%22%3EProtect%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1828316%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20protect%20an%20excel%20workbook%20so%20that%20I%20can%20send%20it%20to%20others%20as%20a%20.xlsx%20file%20(cannot%20save%20as%20PDF%20as%20the%20model%20is%20too%20large)%20so%20they%20can%20view%20it%20in%20excel%20but%20not%20make%20changes.%20I've%20tried%20to%20protect%20function%20with%20a%20password%20but%20when%20I%20save%20it%2C%20exit%2C%20email%20it%20to%20my%20other%20email%20address%20to%20test%2C%20I%20can%20still%20open%20the%20file%20and%20make%20changes%20without%20being%20asked%20for%20a%20password.%20Any%20help%20would%20be%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EJack%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1828316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1829299%22%20slang%3D%22de-DE%22%3ESubject%3A%20Protect%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829299%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F849191%22%20target%3D%22_blank%22%3E%40jacka22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20an%20instruction%20with%20video%20step%20by%20step%20instructions.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EProtect%20an%20Excel%20file%3C%2FSTRONG%3E%3C%2FP%3E%3CDIV%3E%3CDIV%20class%3D%22appliesTo%22%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%20for%20Mac%3C%2FSPAN%3E%20Excel%20%3CSPAN%20class%3D%22appliesToItem%22%3E2019%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%20for%20Mac%3C%2FSPAN%3E%20Excel%20%3CSPAN%20class%3D%22appliesToItem%22%3E2013%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202010%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202007%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%20for%20Mac%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%22%3E%3CFONT%20size%3D%222%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprotect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b599%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CFONT%20size%3D%223%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprotect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b599%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FFONT%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%22%3E%3CH2%20id%3D%22toc-hId--1213974005%22%20id%3D%22toc-hId--1213974034%22%3ELake%20So%3C%2FH2%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprotect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EProtect%20a%20workbook%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprotect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EProtect%20a%20worksheet%3C%2FA%3E%3C%2FP%3E%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%3C%2FA%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%22%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I am trying to protect an excel workbook so that I can send it to others as a .xlsx file (cannot save as PDF as the model is too large) so they can view it in excel but not make changes. I've tried to protect function with a password but when I save it, exit, email it to my other email address to test, I can still open the file and make changes without being asked for a password. Any help would be appreciated!

 

Thanks,

Jack

3 Replies

@jacka22 

Here is an instruction with video step by step instructions.

 

Protect an Excel file

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac
 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

@Nikolino Thank You. I saw this video, although this protection does not work either. I am trying to protect the workbook so that when other users open it, they can see the cells but cannot edit anything.

 

Anyway to do that?

 

Thanks!

@jacka22 

 

If you still get stuck with these instructions, send me a file (without sensitive data) in the next 10 minutes with a description of the cells that you want to block and any areas ... whatever you want to protect.

Protect a worksheet

https://support.microsoft.com/en-us/office/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6?...

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)