Share specific cells on specific sheets with Office 365 users
I have a user who has created a Spreadsheet with 25 tabs. She would like to share this with 25 Office 365 users (Online only - no domain). She wants each user to have view rights over the entire workbook, but have edit rights to a specific range of cells on that users tab.
It looks like you can do this on a traditional network with a domain, but when saved to her OneDrive or to SharePoint, the sharing option doesn't connect with Office 365 - It is still looking for a traditional domain\Username to share with (See http://sharepoint.stackexchange.com/questions/118905/lock-cells-to-certain-people-but-give-access-to-others-in-a-live-excel-online-wo)
Calvin Chan commented
For sharing, please add the owner the ability to allow certain users to see certain
allow different user groups to view and or edit different sheets based on there privileges