View original (French)

Share only one sheet of a Google Sheet file.

angel1910 Posted messages 7 Status Membre -  
 hkim -
Hello,

I would like to share only one sheet in read-only mode from my Google Sheets workbook, and ensure that the other sheets are not accessible or even visible. I would be the only one with access to the complete file (and possibly a few others on a case-by-case basis).

Is this possible?

Thank you in advance for your help!

2 réponses

Réponse 1 / 2
warold Posted messages 79 Status Membre 177
 
Hello,

On Google Sheets it's possible, right-click on the sheet tab and then protect the sheet. Then you manage the permissions as you wish.

Have a nice day.
0
angel1910 Posted messages 7 Status Membre 4
 
Hello,

By right-clicking, I can manage the editing permissions of the sheet but not the visibility.
I would like the people with read access to the file to only see the first tab and not the others.
4
warold Posted messages 79 Status Membre 177
 
Indeed, there are only modification permissions. This feature is not yet offered by Google. Maybe in the future...
0
angel1910 Posted messages 7 Status Membre 4
 
Oh well, that's a shame...
Well, I found an alternative by creating a second file and using the formula
= IMPORTRANGE to transpose the data I want to share.

Thanks anyway for your response.
0
easypask
 
Thank you, I was also looking for this function, I will also use IMPORTRANGE in the meantime.
0