Forum Discussion

KetySemyonov's avatar
KetySemyonov
Icon for Microsoft rankMicrosoft
May 26, 2021
Solved

Excel 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 able to view or make changes.

I check other questions in the forum and I believe the answer is no for the view part, so if I'm correct - is there a way to do that using 3rd party tools or specific coding?

 

(Using 365)

 

Thanks!

excel
office 365
  • JKPieterse's avatar
    JKPieterse
    May 26, 2021
    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.

2 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 26, 2021
    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.

Resources