Excel Workbook Viewing / Editing Permissions

Copper Contributor

I need to share a spreadsheet with my organization. I need to give editing permissions to 2 others and view-only permissions to everyone else. We plan to store the spreadsheet in our company OneDrive or Dropbox. It is currently 11 sheets but the editors will be adding more later. The editors are not familiar with Excel so simpler methods are preferable.

 

What is the easiest way to give editing permissions to those two and view-only access to everyone else? 

1 Reply

You should be able to do a share with specific people with a link (check allow editing) and choose the editors. Once you have done that, click on share again and check can view. Here is a link that should help
https://support.microsoft.com/en-us/office/collaborate-in-onedrive-d8a2a19a-e306-4ca5-9b00-19b0e9689...

Best,
Bp