SOLVED

Excel Protect Workbook feature not working

%3CLINGO-SUB%20id%3D%22lingo-sub-268362%22%20slang%3D%22en-US%22%3EExcel%20Protect%20Workbook%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268362%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20I%20have%20done%20in%20the%20past%2C%20I%20am%20trying%20to%20protect%20sensitive%20information%26nbsp%3Bvia%20Info%2F%20'Protect%20Workbook'%20%2FEncrypt%20with%20Password.%20After%20entering%20the%20password%20twice%2C%20it%20gives%20me%20the%20message%20'A%20password%20is%20required%20to%20open%20this%20workbook'.%26nbsp%3B%20When%20I%20close%20the%20file%20(after%20saving%20changes)%2C%20file%20can%20be%20opened%20again%20without%20a%20password.%26nbsp%3B%20Thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-268362%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-268412%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Protect%20Workbook%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268412%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CSPAN%3EHaytham!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268402%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Protect%20Workbook%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268402%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Veronica%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlad%20to%20hear%20that%20you%20have%20figured%20it%20out%20yourself.%3C%2FP%3E%3CP%3EI'd%20like%20to%20add%20that%20most%20of%20Excel%20functionalities%20cannot%20be%20saved%20with%20the%20.csv%20file%20extension!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EBecause%20this%20extension%20is%20intended%20to%20save%20raw%20data%20only!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIt's%20often%20used%20in%20exporting%20raw%20data%20from%20some%20external%20sources%20to%20Excel!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ERegards%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EHaytham%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268394%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Protect%20Workbook%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268394%22%20slang%3D%22en-US%22%3E%3CP%3EI%20figured%20out%20what%20the%20problem%20is.%26nbsp%3B%20Files%20saved%20as%20.csv%20apparently%20cannot%20be%20password%20protected.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2239462%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Protect%20Workbook%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2239462%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F224894%22%20target%3D%22_blank%22%3E%40VERONICA%20LIPPUNER%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20anyone%20else%20who%20experiences%20difficulties%20with%20password-protecting%20Microsoft%20Office%20documents%20in%20the%20future%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMS%20Office%20does%20not%20allow%20for%20password%20protection%20of%20documents%20saved%20as%20Open%20Document%20Format%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20if%20it's%20a%20powerpoint%20save%20as%20.pptx%20or%20similar%2C%20if%20it's%20word%20save%20as%20.docx%20or%20similar.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EDo%20not%20save%20as%20.odf%20and%20try%20to%20password%20protect.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20wasted%20an%20hour%20figuring%20this%20out%3B%20re-installed%20MS%20Office%20and%20everything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMicrosoft%2C%20consider%20giving%20users%20a%20prompt%20when%20password%20protection%20is%20attempted%2C%20to%20prevent%20this%20waste%20of%20time!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

As I have done in the past, I am trying to protect sensitive information via Info/ 'Protect Workbook' /Encrypt with Password. After entering the password twice, it gives me the message 'A password is required to open this workbook'.  When I close the file (after saving changes), file can be opened again without a password.  Thank you for your help!

4 Replies

I figured out what the problem is.  Files saved as .csv apparently cannot be password protected.

best response confirmed by VERONICA LIPPUNER (New Contributor)
Solution

Hi Veronica,

 

Glad to hear that you have figured it out yourself.

I'd like to add that most of Excel functionalities cannot be saved with the .csv file extension!

Because this extension is intended to save raw data only!
It's often used in exporting raw data from some external sources to Excel!

 

Regards,

Haytham

Thank you Haytham!

@VERONICA LIPPUNER 

 

For anyone else who experiences difficulties with password-protecting Microsoft Office documents in the future:

 

MS Office does not allow for password protection of documents saved as Open Document Format files.

 

So if it's a powerpoint save as .pptx or similar, if it's word save as .docx or similar. 

 

Do not save as .odf and try to password protect.

 

I just wasted an hour figuring this out; re-installed MS Office and everything.

 

Microsoft, consider giving users a prompt when password protection is attempted, to prevent this waste of time!