This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
It looks like a major issue. Many of my colleagues have reported this same issue since today. They can open the file in Excel desktop application and edit the cells but the same cannot be edited online and gives the error ''this sheet is protected. Some parts may be view only and can't be changed'.
This issue has started today for a colleague of mine using a a file I created about 2 years ago, only one user on a team of 19 experiencing this issue.
Have any tickets been created for this? Just so I can give to our IT team here if this needs to be logged by them with Microsoft.
Thank you for your response, Snow Lu. I’ll follow up with our IT team. However, based on Collin’s and Ernie’s replies/exact experiences and the issue starting on the same date (December 11th), it looks like it may not be limited to our individual environments?
Exact same experience here, Collin. We had one user with the issue up until this morning; a second started experiencing it this afternoon.
Our experience is almost identical: files have been in use for a few months, the issue also started on the same date (December 11th) for the user mentioned above. However, another reported that they started experiencing the issue this afternoon.