Forum Discussion
Excel worksheet protection in Excel Online
Does worksheet protection work in Excel Online? We have a workbook where we have set certain ranges for all users (Everyone) to be able to edit without password. Enable protection on the worksheet ...
I figured it out...
before you protect your sheet or workbook, you need to first format the cells.
Select the cells your would like to be edited and right click > format cells> protection tab> deselect the locked box.
Once this is complete you cant then allow editing ranges from the review button within the ribbon. And then you can protect the sheet and or workbook.
before you protect your sheet or workbook, you need to first format the cells.
Select the cells your would like to be edited and right click > format cells> protection tab> deselect the locked box.
Once this is complete you cant then allow editing ranges from the review button within the ribbon. And then you can protect the sheet and or workbook.
Hi,
i've the issue in where I have protected the worksheet so that some collumns are unlocked and editable. The rest of the sheet is locked and cannot be edited. this is working fine if i open the file in the desktop app but i get the emssage this sheet is protected and cannot be edited if trying in excel in browser.
can anyone help me with this ?
matthieu290684 I have the same issue. IN desktop I can unlock some cells and then potect the sheet and it works. As soon as I upload it on share point I can not put data even in the unprotected cells. I can in desktop though. Strange.
- Just tested it out and works OK for me, what version of Desktop are you using? Also, when online go to Help and submit feedback to report the problem
- Thank you. This worked
