Section Access problem Sheet Level

[stonecold111]

hi qlikksss

SECTION Access;

LOAD

ACCESS,

NTNAME

FROM

(ooxml, embedded labels, table is Sheet1);

SECTION Application;

SHEET_LEVEL:

LOAD

NTNAME,

SHEET1

FROM

(ooxml, embedded labels, table is Sheet2);

And i used condtional show for sheet1 as       =ONLY(SHEET1)=1

in my excel file in Sheet1

ADMIN,GOOGLE\SURESH

ADMIN,GOOGLE|SATHISH

USER,GOOGLE\MARTIN

in Sheet2

NTNAME,SHEET1

GOOGLE\SURESH,1

GOOGLE\SATHISH,1

GOOGLE\MARTIN,0

when i relaod through server even for GOOGLE\MARTIN   Sheet1 is visible. Imagine my server is running on GOOGLE\SURESH

account. Even when i logged in as GOOGLE\MARTIN Sheet1 is visible. Any suggestionsss

[trdandamudi]

Did you checked the below two options as circled below ? Hope this helps...

[antoniotiman]

Hi,

try this

=Only({<NTNAME={'$(=Upper(OSUser()))'}>} SHEET)

Regards,

Antonio

[Anonymous]

Hi

Also, Check   in Doc properties  -> Security -> show all sheets and objects is unchecked

[stonecold111]

Yes I did

[stonecold111]

Will try n come back

[stonecold111]

if i use strict exclusion as well with intial data reduction

Failed to open document. you don't have access to this document

[stonecold111]

yes it's unchecked

[stonecold111]

No it's not working

[stonecold111]

still sheet is visible