Create/Set permissions for changing data within range in shared file

Copper Contributor

Hi All!

 

Here is what I have:

Office 365 for business, where users access shared files locally, through synced OneDrive disk.

There is an Excel file, where users should be able to change data only within the range specified.

Questions are:

- how to make Excel file know that those users exist? or

- is it possible to create/setup/add existing users (within single business subscription) to Excel file for setting range permissions?

- is there some other method to do this, I didn't aware of?

 

1 Reply