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 on the protected sheet, as of today it says the cell is protected, even when it's not part of the set of cells that are locked.
Under 'Review - Manage Protection' in Excel Online, there is a new(?) option to add editable ranges, but this isn't visible in Excel Desktop. This seems to override this behaviour where unlocked cells on a locked spreadsheet can't be edited in Excel Online.
Is this an intended change to the way these locked cells on protected sheets work for Excel Online, or is it a bug that has been introduced? Is this the correct venue for reporting something like this? There is a Reddit thread started earlier today that first noted this, I've been using this functionality as described (protected sheets with locked and unlocked ranges) for over a year this way with no issues, with this change happening today: Office 365 Issue with cells randomly locked : excel (reddit.com).
Thanks,
Rob
Seems to be fixed for me as well. Go team!
- on 21/dec seems to be fixed for us as well
Seems to be fixed for me as well. Go team!
Saw this incident report in my M365 dashboard on this issue:
Title: Some users can't freely edit unlocked cells in protected Excel files opened in Excel for the web
User impact: Users couldn't freely edit unlocked cells in protected Excel files opened in Excel for the web.
More info: Some users modifying unlocked cells in protected Excel for the web files would receive a prompt that the cells were protected. Affected users could have bypassed the problem by opening files in the Excel desktop app, if accessible.
Final status: We've disabled the offending changes and confirmed through an additional period of monitoring that the issue is resolved throughout the affected environment. Users encountering persistent impact may need to refresh their Excel for the web session to see remediation.
Scope of impact: Some users are impacted when attempting to edit unlocked cells in protected files through Excel for the web.
Start time: Sunday, December 10, 2023 at 7:00 PM EST
End time: Wednesday, December 20, 2023 at 3:05 PM EST
Root cause: Two recent changes to introduce a new feature that was intended to improve the content latency in Excel for the web resulted in impact.
Next steps:
- We're reviewing our update testing and validation methods to better identify the potential for issues such as this prior to deployment to prevent similar impact in the future.This is the final update for the event.
Hi RobertAttrell,
We had the same problems but as of today, it seems fixed.
Is it fixed for you too?
With kind regards,
Wouter
- Hi all,
I just get news from our team and it seems the users who had issues are able to work normally again. So it seems to be fixed for us.
Kind regards,
Mitchel
- I've done the same and gone through with support tech yesterday - they are aware of an issue which is good, but no plan on turnaround times..
- I went through the issue with a support engineer just now and sent them the diagnostic files from the system, they are aware of the issue, I'll post again if I hear anything definitive.
- Our customers cannot use our Excel Online sheets because of this bug. Hopefully issue is solved ASAP
- Just jumping in to say I am having the same issue in my organization. Excel Online is locking ALL the cells instead of just leaving the range opened. My only temporary workaround is asking users to refresh the page, or change the Editing drop down box in the top right hand corner to Viewing Only then back to Editing and see if it helps.
Hope this is fixed soon. - Hey, since nobody seems to have an ability to let Microsoft know in an official capacity, I tried submitting an official Microsoft support ticket through 365. I got word the team involved on Excel Online is aware of the issue now, I will post an update here if I hear more.
- Good morning Robert. Any report back from support? Yesterday I went through approximately 1000 worksheets within 150 workbooks on the online version to get these sheets to work again for my company.
RobertAttrell Please keep us updated on anything you hear from Microsoft on this issue. I have a LOT of work ahead of me if this is not fixed very soon. Thanks!
- Microsoft need to fix this ASAP. There are hundred of people in our organization can't do work because of this protected cell bug.
My organization is facing the same issue, tons of Excel files that had locked/unlocked cells are now randomly locking cells that were not locked previously. Tons of users in our org are having issues with various Excel files we have in use. The issue is rectified by opening the file in the desktop app, but using Excel Online we experience all these issues suddenly.
