I'm controlling the sharepoint site for my work group and we have a shared excel doc that everyone uses daily but it doesn't have any privacy ( all information each person adds will be visible to everyone else who uses the doc ). all users have to log into the site individually. is there any way for me to set that document up so that each user can only see what they have added and it all compiles on the back end?
Add a comment
|
3 Answers
Unfortunately, you can't manage the users' permission on the document content. but, you can manage the permission per document where specific users can see a specific document based on the assigned permission!
If you can divide this Excel file to separate files, you will be able to assign permission for each file for the users who should see the file content!
For more details check User permissions and permission levels in SharePoint
answered Oct 19, 2017 at 18:02
-
@dave you are welcome, Please don't forget to mark & upvote the correct answer as accepted in case it helped you, also please have a tour to get an informed badge at sharepoint.stackexchange.com/tour Thanks! Commented Oct 19, 2017 at 18:16
If the content of the Excel file is formatted as a table, and you don't have much formulas in the Excel document, consider importing the Excel table into a SharePoint list, then have users interact with the SharePoint list. You can set permissions in the list settings page.
-
I agree - it's better to use a Sharepoint List instead of an Excel file, unless there is a good reason not to. Then you can make use of Sharepoint's useful features - for instance you build up a history of each line item, every time a user changes something. You can also manage security better - split users in to 'read-only' and 'read/write' groups.– TallyCommented Oct 23, 2017 at 9:40
You may also wish to activate Versioning, this will keep track of who has edited the document and build up a history. Go in: Document Settings>Versioning Settings>Document Version History (choose 'Major' or 'Major and Minor' versions).
You can also configure whether or not users can see previous versions of the file from the version history.
