Forum Discussion
Solved
Protected sheets with unlocked cells shows all cells as protected in Excel Online
Hi, I first noticed this today with Excel Online. I have a workbook with a protected sheet, some cells are locked and some aren't. On the desktop, this works fine. On Excel Online, when editing cells...
Seems to be fixed for me as well. Go team!
We have the same issues in our company.
The weird thing is that it's not affecting all users. For some users it's working as usual and other users can't do anything anymore as it seems that the unlocked cells are locked for them. So for those users I need to unprotect the full sheet to have them do their work.
I hope this can be fixed as soon as possible because we really rely on excel online where we have 20 excel tabs open at the same time.
Or if we need to change the process then hopefully someone from Microsoft can tell us what to change to have our protected excel files workable again in excel online.
The weird thing is that it's not affecting all users. For some users it's working as usual and other users can't do anything anymore as it seems that the unlocked cells are locked for them. So for those users I need to unprotect the full sheet to have them do their work.
I hope this can be fixed as soon as possible because we really rely on excel online where we have 20 excel tabs open at the same time.
Or if we need to change the process then hopefully someone from Microsoft can tell us what to change to have our protected excel files workable again in excel online.
Exactly the same behavior for us, appears random, it's random cells that are inaccessible. It started for me and I could select 3 cells in one row but the rest of the rows were fine. Very weird behavior. I ended up having to use the online Manage Protection to add a range, even though they are not locked via cell formatting, and then locked the sheets. That resolved it for online use. However you have to do that for every sheet and every cell you want them to have access to. So unpleasant if you have a lot. I had 2 workbooks and a total of about 10 sheets to update. Everyone is able to continue using them online now. Hope Microsoft fixes this soon.