Jul 13 2022 11:54 PM
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 | Department | Project title | start date | end date | Status |
USER 1 | |||||
USER 2 | |||||
USER 3 | |||||
USER 2 | |||||
USER 3 |
Jul 14 2022 10:09 PM
@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.