Google-sheets – make a sheet private in a Google Sheets

google sheets

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?

Best Answer

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.)