question

ValentinaLemiakinaVincisarl-6873 avatar image
0 Votes"
ValentinaLemiakinaVincisarl-6873 asked ·

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

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.

office-onedrive-client-itpro
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered ·

@ValentinaLemiakinaVincisarl-6873

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.



capture49.png (11.0 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ValentinaLemiakinaVincisarl-6873 avatar image
0 Votes"
ValentinaLemiakinaVincisarl-6873 answered ·

Thank you, Emilyhua, it is clear.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.