3

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?

1

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

1

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. – Tally Oct 23 '17 at 9:40
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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