Very simple Issue but still an issue

[#1]

I am trying to implement sestion access so when user opens file from access point , they could only see thier DIVSION,, but this does notseems to be working and i am able to everything. Please help/guide me if my code is incorrect.

SECTION Access;

LOAD Upper(NTNAME) as NTNAME,
     ACCESS,
     DIVISION
FROM
Data.xlsx
(ooxml, embedded labels, table is Security);


SECTION Application;
DATA:
LOAD DIVISION,
     [Gross Sales],
     [Net Sales]
FROM
Data.xlsx
(ooxml, embedded labels, table is DATA);

[PrashantSangle · Accepted solution]

Hi,

Have you check

Setting->Document Setting->Opening->Initial Data Reduction on Session Access->check it

Regards

[Anonymous]

hi

Please check the option of

Initial data reduction on section access in document properties.

Thanks,

NIshant

[#4]

Damn,,, Thanks how come i forgot that.