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.