SharePoint excel sheet with limited user access

Copper Contributor

Hi, 

 

How to make a OneDrive shared excel sheet that users are not able to see each other's data. Only admin can see the whole data, but users can view and update their data only.

 

Let's say there are 3 users, USER 1 cant see USER 2 and USER 3 data when it's open.

 

excel sheet sample

name DepartmentProject titlestart dateend dateStatus
USER 1     
USER 2     
USER 3     
USER 2     
USER 3     

 

1 Reply

@Bindi2022 Don't make life difficult for yourself. Either use a different spreadsheet file per person and aggregate them in the admin's file, or use SharePoint lists that are similarly aggregated.