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 ...
Hi, I was able to figure out why this happened to me. Even though I had setup Edit Ranges etc. in the required columns, I was not able to edit in Excel Online (through Sharepoint).
I later figured out the reason was because the file which i built upon, had cells locked in "Format Cells" Option. Once I disabled that option, I was able to edit in Excel Online.
Hope this helps for others too!!
Since i cant paste a picture of where to find it, please use this link below (Read the 4th Point).
https://support.microsoft.com/en-us/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a
I later figured out the reason was because the file which i built upon, had cells locked in "Format Cells" Option. Once I disabled that option, I was able to edit in Excel Online.
Hope this helps for others too!!
Since i cant paste a picture of where to find it, please use this link below (Read the 4th Point).
https://support.microsoft.com/en-us/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a