Bypassing Section access for some sheets

Aspiring_Developer — Fri, 11 Sep 2020 13:52:50 GMT

Hello Everyone,

Please help me with the below as i am not able to figure out a way please:-

I have section access applied at company code , for instance:-

ACCESS

USERID

Control

Company

USER	AD\NACHO.MARTINEZ	<ANY>	0701
USER	AD\NACHO.MARTINEZ	<ANY>	8100

Now these users can only see the data for the mentioned company codes.

But for some sheets , i want them to see the data for all the companies.

So, is there any way that we can bypass the section access rule for some sheets.

Please please help, have searched everywhere , did not find anything. Please help.

Re: Bypassing Section access for some sheets

Nicole-Smith — Fri, 11 Sep 2020 20:06:58 GMT

The access is applied upon opening the document, so you cannot bypass it on specific sheets. You have two options here:

Load the data you don't want to apply the section access to as a data island (not connected to the data that you have applied the section access to)
Create a second app that contains the data you want visible to all and implement document chaining to send them from one app to the other