Sheet Sharing Question
I have a master sheet of data that feeds a number of sub sheets. I need to share one of the sub sheets with someone that can't have access to the master sheet. When I share the sub sheet with this individual, they cannot see the data on the sheet, and I think that is because they do not have access to the master sheet. Can anyone confirm if 1) this is correct, and 2) is there a workaround to this that will let this person access the sub sheet without first having to get access to the master?
Thanks in advance for any assistance.
Comments
-
When you say sub-sheets are you referring to them actually being reports?
If so, the users would not be able to view the data in the reports without having access to the sheet where the data is coming from unfortunately.
Are you needing them to be able to edit the report? If not and you're happy for them to just have view only access then you could publish the report. This allows someone to view it in view only mode without needing to access the mastersheet.
