Forum Discussion
Locking cells in Excel Online? Is it possible?
You have to apply the protection in the desktop version (for Windows or Mac). If you then upload the workbook to the cloud and open it in Excel Online, the protection will still work.
(Protecting is a two-step process:
- Unlock the cells that should be editable in the Protection tab of the Format Cells dialog.
- Protect the worksheet on the Review tab of the ribbon.)
Solved this one today. All the other comments only partially solve our problem. We had several protected sheets with specific cells locked, but there one sheet would not lock when Excel file open in Teams. Setting the protection was only part of the solution.
With Excel file open in Teams. Go to Review tab > Manage Protection > (enter password if password protected) > Protect Sheet (on) > Unlocked Ranges (none).
The key was Unlocked Ranges.
Removing any ranges listed in the Unlocked Ranges section solved it.
Hope this helps someone because it took ages to figure this one out.
