Forum Discussion
Solved
Locking cells in Excel Online? Is it possible?
Microsoft's website claims that the online version of Excel has a feature that will allow you to lock certain cells so that they can't be accidentally overwritten, but it doesn't explain how to do it...
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.)
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.)
Hey, I've set up some access premissions like this - opened and created in excel app, apply access rights to all cells but one section allowing user 1 access and not user 2.
On this other section I've allowed user 2 rights to access. All works well in the excel app - however when this is opened through teams, it will always ask for the password to be given.
Is there a way around this?
