Forum Discussion
Display rows and sheets based on user, office 365
Hi, I would like to know if I can use Excel 365 to share a file with 15 people and have them all work at the same time. The issue is that I need 5 people to have full access to the file. The other ...
Not out of the box, no. Excel isn't designed to handle users with different viewing rights within the spreadsheet. What you are describing is typical database technology: role-based access to records based on proper rights management.
To do this in Excel, give each of the restricted persons a separate file to work in, in his/her own folder. Then have a separate workbook which pulls in the records from the individual files using Data, Get Data, From File, From (Sharepoint) Folder.
You grant access to this consolidation file only to the 5 "main" users.