Parametering modification possibilities of an Excel file, shared on OneDrive, for different users.

2021-03-17T14:45:58.317+00:00

Hi. We are a soft developer company from France. We use Onedrive for file sharing in our everyday work and with the clients. We are searching for a way to restrict possibilities to m o d i f y a part of a shared Excel file among specific users, letting them s e e the whole file ? With “information barriers” tuned somehow, or other.. What OneDrive User identity parameter might be used forsuch permissions/restrictions ? Thanks.

OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
802 questions
No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 21,851 Reputation points Microsoft Employee
    2021-03-18T07:56:49.387+00:00

    @Valentina Lemiakina, Vinci sarl

    If you want to set the restriction for part of a shared Excel file, I suggest you use the "Allow Edit Ranges" feature in Excel.
    As the OneDrive settings I find, such as "information barriers", are for the whole Excel file or a folder.

    To use "Allow Edit Ranges" in Excel, you may refer to "Allow specific users to edit ranges in a protected spreadsheet". Then you may let these specific users know the password. Once they enter the password on the windows like following image, they could edit the specific ranges.
    (Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)
    79028-capture49.png
    Besides, "Allow Edit Ranges" feature is not available for Excel Online yet, even user has a password, they cannot edit this Excel file online.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments

1 additional answer

Sort by: Most helpful
  1. 2021-03-19T15:53:58.75+00:00

    Thank you, Emilyhua, it is clear.

    No comments