Forum Discussion

Michael Bennett's avatar
Michael Bennett
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
IngeborgHawighorst's avatar
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?

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Jul 15, 2019

GHepburn I just created a new workbook, unlocked some cells and formatted them with a green fill. I protected the worksheet and saved the file to my personal OneDrive. Then I edited the file in the browser with Excel online. I was not able to change the locked cells, only the unlocked green cells in column B.

 

If your experience is different, please provide the steps that you took.

  • Oristelle's avatar
    Oristelle
    Copper Contributor
    Feb 20, 2020
    Hi, I’ve locked some cells and protected my sheet in the app. I’ve uploaded to sharepoint. The protection works fine but when a user copy and paste in the spreadsheet it locked the cells and it can’t be unlocked in the app. I have to open in the app, unprotect the spreadsheet and rework the locked / unlocked cells. Very tedious (as it can only be done when no one is using the spreadsheet). Anyone has the same issue ?
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jul 29, 2019

    Randall1508 with Excel online it's currently not possible to remove sheet protection in the browser, so the scenario you have in mind will not work that way.

     

    Mind you that sheet protection is not a security feature and can easily be circumvented. 

  • Randall1508's avatar
    Randall1508
    Copper Contributor
    Jul 27, 2019

    HelloIngeborgHawighorst I want to create a file with several sheets, and I want to share the file online with different people. Is there a way in which I can protect each sheet with a password, so each participant has access only to his own sheet like I can do with desktop Excel? Thank you.