Forum Discussion
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 ...
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.
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.
- 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 ?
