2 Replies Latest reply: Apr 25, 2016 4:02 PM by Enrique Colomer RSS

    Hiding sheets in Access point - Section Access

    Santosh Prabakar

      I have a requirement to hide few sheets depending on the user logging into the access point to view the app. I'm trying to implement section access but so far not successful. If I check the strict exclusion, none of the users are able to access the app in the access point. It says..the user don't have the permission.

       

      If I uncheck the strict exclusion, All the tabs are visible to all the users. Please advise what am I missing here. Attached is the excel.

       

      Section Access;

      LOAD NTNAME,

           USER_ID

      FROM

      [..\ExternalData\SA_JMPN_Exec.xlsx]

      (ooxml, embedded labels, table is Section_Access);

       

      Section Application;

      LOAD NTNAME,

           USER_ID,

           SH01,

           SH03,

           SH04,

           SH05,

           SH06,

           SH07,

           SH08

      FROM

      [..\ExternalData\SA_JMPN_Exec.xlsx]

      (ooxml, embedded labels, table is Section_Access);