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

[Siva_Sankar]

Can you debug and ensure whether the user name and sheet name exactly matches including the case by creating two different text box with the formula below.

Text box 1 =OSUser()

Text box2 = =GetActiveSheetId()

See the user name and sheet name matches with section access file.

[jmvilaplanap]

Then

SHEET1

Because it has only a row, and the value will be 1 for the people that can see the page.

[stonecold111]

i used upper function and it's working fine in access point

But when i open qvw in qlikview application in my server it is hiding that sheet

i don't want that sheet to be hidden in my qlikview app

[stonecold111]

yes i did