I need to create Excel on-line workbook with different permissions sheets. more like some users can see some sheets while other can't edit, etc.
can I achieve this?
Different permission for different user on Excel Online
excel-onlinepermissions
Related Topic
- Does Excel Online support filtering columns by value
- Excel Online – How to Fix Filtering Issues
- Office 365 – Using Excel Survey in Office 365 for Business
- Google-sheets – How to share different tabs in the same Google Sheet with different people/groups
- Forbid users to delete files on shared OneDrive folder
- Google Drive – Different URLs for Edit and View of Same Folder
Best Answer
You can allow certain users to edit certain areas of the sheet by using "Allow Users to Edit Ranges"
https://support.office.com/en-au/article/Lock-or-unlock-specific-areas-of-a-protected-worksheet-bdb8252f-d605-45cb-9712-137925867ad4
You can setup a way to hide certain sheets with a login via macros but it need some coding that is beyond my scope currently