Section Access restrict different users

[#1]

SECTION Access;
LOAD NTNAME,
ACCESS
FROM
QVSecurityMatrix3.xls
(biff, embedded labels, table is Sheet1$);

SECTION Application;

LOAD NTNAME,
SHEET1,
SHEET2,
SHEET3,
SHEET4,
SHEET5
FROM
QVSecurityMatrix3.xls
(biff, embedded labels, table is Sheet2$);

My loading of section access is as shown above.

This is sheet1.

This is sheet2.

I am log onto the computer as OCBCGROUP\A9900899.

My question is why does SHEET2 not show when I changed APAC\A44682 SHEET2 to 0? I have used the same condition for sheet2 as I did for sheet1 shown above. eg(=IF(SHEET2>0,1,0). I am Logged on as OCBCGROUP\A9900899 and not APAC\A44682. I should be able to see SHEET2 as shown in the excel. How do I solve this issue as such I will be able to view SHEET2 but APAC\A44682 will not be able to view SHEET2? Thank you

[sravanthialuval]

Hi,

You Should have to give condition for every sheet with, field name of that corresponding sheet mentioned in the script.

for example:

In sheet 1 you have to give  filed name of this particular sheet in conditional.

In sheet 2 you have to give  filed name of this particular sheet in conditional.

Like this give condition to all  the sheets and enable  the below option in settings->document properties->

opening.

[#3]

Hi I followed your method but it does not work. what should I do?

[sravanthialuval]

It's working for me. you have to cross check the application, whether you are giving correct filed names or wrong.if possible it is better to create a new application and proceed with this method.