Excel Sharing access

Copper Contributor

Hello,

 

When I want to share a Excel file with multiple people, the only option I am offered is whether they can read or edit the file. 

I need several people in one Excel file to have defferent access to different sheet of the file.

Is that possible?

4 Replies

@Marijas391 

It is possible to assign different access permissions to different sheets within an Excel file when sharing it with multiple people.

Here is how you can do it:

  1. Open the Excel file that you want to share.
  2. Go to the sheet for which you want to set specific access permissions.
  3. Right-click on the sheet's tab at the bottom of the Excel window and select "Protect Sheet" from the context menu.
  4. In the "Protect Sheet" dialog box, you can set a password if desired, and then specify the options you want to allow or restrict for that particular sheet. For example, you can choose to allow or disallow actions such as formatting cells, inserting/deleting rows or columns, sorting, filtering, etc. Configure the options according to the access permissions you want to grant to the users of that sheet.
  5. Click "OK" to protect the sheet with the specified permissions.
  6. Repeat steps 2-5 for each sheet that requires different access permissions.

When you share the Excel file with others, they will be able to access and interact with the sheets according to the permissions you set for each sheet. Each sheet can have its own set of permissions, allowing you to control the level of access and functionality for different users or groups of users.

It's important to note that this method provides sheet-level protection and permissions within the Excel file itself. It does not control the access permissions at the file level (read or edit access) that you mentioned earlier. To manage file-level access permissions, you can use the sharing and collaboration features of your chosen file storage and sharing platform (such as OneDrive, SharePoint, or a shared network folder) or any external access control mechanisms provided by your organization's IT infrastructure.

 

@NikolinoDE 

 

I know for that option "protect the sheet", but everyone can still see that sheet. I need to protect it so that some users cannot see the content of the sheet, but can see the content of other sheet... 

@Marijas391  Hi, have you succesfully managed to solve the issue you mentioned? Im trying to solve the same issue currently. :\

Thanks