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

Adam86

Copper Contributor

Jun 11, 2019

Michael Bennett

Hello

I have the same problem, did Microsoft come up with a fix for this as it is stopping me sharing a database that I have created.

Any help would be great.

Regards

Adam,

GHepburn

Copper Contributor

Jul 15, 2019

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

Wyn Hopkins
MVP
Jul 15, 2019
Hi

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