Section Access Issue

[raju_salmon]

Hi,

I have an issue while implementing section access, please help me to solve this issue. Attached section access table (sheet 1 is to restrict data and sheet 2 is to restrict dashboard tabs)

I have two tabs in my dashboard, Tab 2 should be hidden to user 2 (i.e., myself), in sheet conditional option =RESTRICT i used and it is hidden when i open in my desktop (CTS\RAJU_R) however when i open in QMC, it is giving an error "Failed to open document, You don't have access to this document." I have used below script. I have done all necessary option changes in document (in document properties)

SECTION Access;

LOAD USERID,

     ACCESS,

     NTNAME,

     STORE

FROM

[..\Data\SA Data.xlsx]

(ooxml, embedded labels, table is DBA);

SECTION Application;

LOAD USERID,

     RESTRICT

FROM

[..\Data\SA Data.xlsx]

(ooxml, embedded labels, table is SheetAcces);

If i use below script it is working, but when i add second part of above script it is not working in QMC

SECTION Access;

LOAD USERID,

     ACCESS,

     NTNAME,

     STORE

FROM

[..\Data\SA Data.xlsx]

(ooxml, embedded labels, table is DBA);

SECTION Application;

Thanks in advance for your help

Raju

[m_woolf]

I don't know if it is related, but I get an error opening the Excel file. Excel says the file is corrupt and asks me if I want to repair it.

[raju_salmon]

Thanks for the reply. I have tried with QVD and still it is not working.

[neha_shirsath]

Can you resend that excel file or send your qvd because its not opening.