unable to login as user after implementing section access

[#1]

Hi

sunindia‌   @Sunny T

I have implemented section access to provide sheet level access to Users.

My excel file data

My script for section access to users

with the above code, I am able to login as USER A but not as other user(B,C, D)

I am getting the errors as "Access denied to this document".

can anyone please help me with this.

Thanks in Advacne

[#2]

if you login as a admin you can able to see that sheet.in further it's not required you can remove.

[Chanty4u]

based on ur requirmnt u can do the changes

[#4]

you mean, we have to remove the sheet manually by after logged in as user?

and also, i have doubt on excel sheet, we are assigning the sheet IDs directly to user through inline, than what is the use of loading the excel sheet in my case. could you please explain me this?

Thanks in advance..

[#5]

In this case no need to load excel sheet directly you can load your source file based on your requirement

[#6]

see the sheet properties....>General tab you will find the condition.

Based on this condition it will work .

[#7]

actually, i have started working on server since a week ago, this is my first time working on section access, could you show me, how to use excel sheet in this case, so that i can use it in future,

i think, if we use excel sheet for sheet level access using 0s & 1s , we can give give access of more than one sheet to a particular user easily.

if i can learn this, it will be advantageous in future.

since you know, my knowledge on section access, you would better explain me this than anyone else

Thanks in advance.

[#8]

I don't think this will  work in excel better use inline load more over we are writing some conditions on sheet properties.

so inline is the better way.

[#9]

yeah, i have seen the sheet condition in sheet properties, it is very easy..

than,  can i remove the excel sheet loaded.. May i know, than why did you loaded the excel sheet, if you are applying the condition in sheet properties.

and could you please help me, I am unable to reload the application, after doing any changes to the script,

[#10]

I thought excel was source file That's way i loaded excel.

yes.You can remove the excel.

Whit is the error you are getting

[#11]

actually i anm getting error as not responding.

when i edit something, and reload this is the error, i am getting

tually