I have a Google Sheets with multiple sheets. The first sheet pulls data from all the other sheets. I need to share the first sheet with all users but I only want to share the rest of the sheets to certain individuals (so not all users of the Sheets can view them, but all users will have to be able to edit their individual page).
Is this possible?
This question came from our site for computer enthusiasts and power users.
I'm pretty sure that the correct answer is that you need to create separate spreadsheet files, with individual privacy settings for each, and one of them pulling data from the other sheets.
(it's unfortunate that Google calls the files "Google Sheets" and that worksheets within them are also called sheets. Very confusing.)
Yes you can do it. For doing this you need to mark the Private option when you create the sheet which you want to create for you.
In addition to the other submissions, using the Named and Protected Ranges option, you can adjust permissions for each sheet. Add a protected range for each sheet, and within each sheet, adjust permissions to suit your needs.
I'm trying to do the same thing. I fear the answer is you can't. For me, this really limits the usefulness of Google Sheets. It seems every time I try to do something I get the same answer. You can't.
