Forum Discussion
Excel Protect Workbook feature not working
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
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!
I know this is a very old thread but this is a valid issue.
I have an Excel spreadsheet with multiple tabs. The workbook is saved as an ".XLSX" file. I believe this is considered "open document format".
Most of the tabs have protected cells that are properly protected using the "locked cell" and "protect sheet" commands.
However, I have one tab that is setup the same exact way as all other tabs (cells are locked, same protections) but the locked cells do not remain locked when the sheet is protected. It is extremely frustrating for this feature to work on some tabs but not all. It is NOT because of the ".XLSX" file format otherwise none of the sheets would be protected.
Is there a way to fix this?