SharePoint excel sheet with limited user access

Question

Hi,&nbsp;&nbsp;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.&nbsp;Let's say there are 3 users, USER 1 cant see USER 2 and USER 3 data when it's open.&nbsp;excel sheet samplename&nbsp;DepartmentProject titlestart dateend dateStatusUSER 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USER 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USER 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USER 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USER 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

mikewww · Answer

Bindi2022&nbsp;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.&nbsp;&nbsp;&nbsp;

Forum Discussion

SharePoint excel sheet with limited user access

1 Reply

Resources

name	Department	Project title	start date	end date	Status
USER 1
USER 2
USER 3
USER 2
USER 3