Forum Discussion

Brass Contributor

Dec 12, 2017

Excel worksheet protection in Excel Online

Does worksheet protection work in Excel Online? We have a workbook where we have set certain ranges for all users (Everyone) to be able to edit without password. Enable protection on the worksheet ...

excel

Excel Online

GHepburn

Copper Contributor

Jul 15, 2019

I have the same problem is there any fix planned for this?

Wyn Hopkins

MVP

Jul 15, 2019

I just unprotected some cells in Desktop, protected the sheet, published to OneDrive, opened it online - protection is working. Opened in Excel desktop, protection is working.

Are you getting a different result?

IngeborgHawighorst
MVP
Jul 15, 2019
The original question is from 2017. Excel online has come a long way since then.

What was not possible then may be possible now.

Please take into account the posting date of the question and consider that the feature set may have changed since it was asked.
- GHepburn
  Copper Contributor
  Jul 15, 2019
  IngeborgHawighorst Ok so I choose the edit in excel option and locked a range of cells however when accessing the online version the users can still edit cells I do not want edited, I also see a comment from a few weeks ago highlighting the same issue
  - IngeborgHawighorst
    MVP
    Jul 15, 2019
    GHepburn After locking the cells, did you protect the sheet? Can you detail where the workbook is saved? SharePoint? OneDrive? OneDrive for Business?