I have a list of about 1000 employees with their addresses and phone numbers which I want to upload to a 2007 SharePoint in list format, which I know how to do, however due to data protection, managers are only able to view their own employees details.

For example, I have John Smith and his contact number is 12345678987, his manager is Joe Bloggs. I will upload this through an excel sheet to my SharePoint where everyone can access this information, however I do not want a different manager to see John Smith's details.

The SharePoint is linked to our network and uses the managers logins, is this something I can use to limit the access?

  • If this cannot be achieved with Excel, can it be achieved with Access? Thank you Jan 20, 2015 at 23:57

1 Answer 1


If you want actual security in place, then you should break the inheritance and provide item level permission.

i.e give explicit permission to manager Joe Bloggs to all employee items where Joe Bloggs is the manager.

Another option is to create a View which filter "Manager = Current User". And remove all other views. Don't give permissions to managers to modify the view. This way managers will only see their employee details.

  • Ok great thank you for the quick response, however how would I give the manager access to his employees on bulk? I will also need to update the SharePoint weekly with a data, this will mean uploading another excel sheet. Wont this break the permission levels? Jan 21, 2015 at 0:00
  • In that case I think the View approach will be easier. Jan 21, 2015 at 0:01
  • Thats great, however how do I make it show only current user? I have changed the view options to limit only when "manager = current user" but what do I enter in this cell for it to look for the current user? And what do I enter into the managers cell. Their login? Or their full name? Bit complicated to explain without showing you :) Jan 21, 2015 at 0:09
  • You can create view and filter Manager Field "equals" [Me] Jan 21, 2015 at 0:11
  • Brilliant, now how do I change the manager column to be a 'Person or Group' type, as this was uploaded from Excel Jan 21, 2015 at 0:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.