Forum Discussion
KetySemyonov
Microsoft
May 26, 2021Excel worksheet permissions
Hello
Is there any way to set up specific permissions on different worksheets in one Excel file? Meaning, that one person will be able to see and edit the worksheet, and second person will not be a...
- May 26, 2021What kind of information does the file contain? If the information is sensitive I would recommend to make sure the file only contains the information a user is allowed to see. All other options may lead to situations where the knowledgeable user will be able to get at information that was not intended for him/her to see.
In my opinion, Excel is not the right tool for this job. A database system -including the right setup of users and roles- is.
JKPieterse
May 26, 2021Silver Contributor
What kind of information does the file contain? If the information is sensitive I would recommend to make sure the file only contains the information a user is allowed to see. All other options may lead to situations where the knowledgeable user will be able to get at information that was not intended for him/her to see.
In my opinion, Excel is not the right tool for this job. A database system -including the right setup of users and roles- is.
In my opinion, Excel is not the right tool for this job. A database system -including the right setup of users and roles- is.
- KetySemyonovMay 30, 2021
Microsoft
Thanks for the reply! I got the information I need