Nov 13 2020
04:11 AM
- last edited on
Feb 10 2023
02:32 PM
by
TechCommunityAP
Nov 13 2020
04:11 AM
- last edited on
Feb 10 2023
02:32 PM
by
TechCommunityAP
We have an excel document to collect team members commission information. Every team member maintains own data in different worksheet in this file. But as it's sensitive data, everyone should only be able to access his/her own data or their own team's data, not other people or teams. Can anyone suggest a way to realize it?
Nov 13 2020 08:26 AM
There's no such feature afaik, best use separate workbooks.
Nov 15 2020 08:39 AM - edited Nov 15 2020 08:45 AM
Search on “protect Excel worksheet”, should give you something. You can prevent others from editing Excel data in three ways. 1) password protect the file. 2). Protect cells. 3) Protect worksheets.
It’s been too long since I’ve done this, I can’t pull the answer out of my head. Second thought, scratch this. I don’t think this allows you to restrict access for certain team members. It becomes an all or none feature.