Dec 18 2023 01:56 PM
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
Dec 18 2023 02:43 PM - edited Dec 18 2023 02:44 PM
Dec 18 2023 02:43 PM - edited Dec 18 2023 02:44 PM
Yes this same thing is happening to us. It started end of last week and having the user open the application on their desktop and syncing seemed to work but now I'm able to replicate the issue myself and syncing is not helping anymore. I can either leave the sheet unlocked or have users open them in the app instead of the browser. Not sure what happened recently to change the behavior.
Dec 19 2023 01:08 AM
This same thing is happening to us. It started at the end of last week but not for all the users or all the Excel files. It seems that opening the Excel file on their desktop seemed to work.
This is a serious functionality error in the application that, if files are to be used, leaves the sheets unprotected, turning it into a serious security breach.
Dec 19 2023 05:17 AM
Dec 19 2023 06:25 AM
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.
Dec 19 2023 07:50 AM
Dec 19 2023 08:02 AM
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.
Dec 19 2023 09:58 AM
Dec 20 2023 07:18 AM
@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!
Dec 20 2023 07:19 AM
Dec 20 2023 07:59 AM
Dec 20 2023 08:00 AM
Dec 20 2023 12:03 PM
Dec 21 2023 01:03 AM
Dec 21 2023 01:19 AM
Hi @RobertAttrell,
We had the same problems but as of today, it seems fixed.
Is it fixed for you too?
With kind regards,
Wouter
Dec 21 2023 03:22 AM
Dec 21 2023 04:16 AM
SolutionSeems to be fixed for me as well. Go team!
Dec 21 2023 04:44 AM
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.
Dec 21 2023 05:30 AM
Dec 21 2023 04:16 AM
SolutionSeems to be fixed for me as well. Go team!