Forum Discussion

Copper Contributor

Oct 08, 2018

Solved

Excel Protect Workbook feature not working

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...

excel

office 365

Haytham Amairah
Oct 08, 2018
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

Superwin

Copper Contributor

Jul 02, 2021

Absolutely right. If its saving as CSV then just have a pop up to say, Hey guys, this wont work with CSV format. Ive already now had to repair my laptop from throwing it across the room in frustration before i found this. Microsoft, you dicks...Lianne_Abrahams

bitreactor

Copper Contributor

Jul 12, 2021

Took me 20 minutes to figure this out. Please just add a prompt that you can't encrypt CSV files. This seems like a BIG SECURITY hole since a user might assume the password protection worked.

vic_0225
Copper Contributor
Sep 30, 2022
My problem: My Excel spreadsheet was created and encrypted using MS Office 2010. As I have just learned, Microsoft Office 365 which is built into my new HP laptop does not support "password protection." MS 365 automatically migrated all of my other old (password unprotected) Excel files, making them ineligible for encryption. So now, I am left with inability to encrypt any Excel spreadsheet.