A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
This issue appears to have been fixed. the users i could contract immediately say they are not having problems anymore.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
We have a team working on Excel files online (in the browser). The files:
I have one user who randomly cannot edit unlocked cells on a protected sheet, receiving the error message "This sheet is protected. Some parts may be view-only and can't be changed". The unlocked cells are surrounded by locked cells, and some of the unlocked cells are merged. The issue could appear when opening a file and then not be present when the file is opened again later. It is not specific to any particular file; it can happen to any file.
It's interesting to note that all other users with the same permissions can simultaneously work on these files without the issue, even while the user in question is experiencing the block/issue. Also, the user is able to edit cells with the same protection set up on other sheets, but could later be blocked on these same sheets when re-opening the file at another time. Recreating this issue is not consistent.
The cells locked/unlocked property has been set via 'Protection' tab in the 'Format Cells' dialog in Excel desktop. The sheet's protection has also been set in the desktop app.
I have tried:
Any ideas for why this particular user may be experiencing this issue?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
This issue appears to have been fixed. the users i could contract immediately say they are not having problems anymore.
Same problem for my team since some days, but it's not only one personne and others no, it's for all.
When an unlocked cell is empty, they can add something inside, but then the cell became locked and impossible to change anything. Only me (the creator) doesn't have the problem, and I used the file online to, as my teams does. But all the other users that can modify my files have the probleme. I had to completely unlock the sheet for all for them to make changes, but it's risky because they can even make modifications on cell uselly locked...
Hope Microsoft will resolved as soon as possible...