Document with Section Access opens with no authentification

[Anonymous]

I have evoked Section Access into my QV document as follows:

Section Access;
Directory;
LOAD ACCESS,
USERID,
PASSWORD,
RETAILPHARMACY,
OMIT,
PATENTS,
FDA,
GENERICS,
SHOPPING,
PLAZA_ANALYTICS,
_VIEWGROUP
FROM
[..\Data Files\SectionAccess.xlsx]
(ooxml, embedded labels, table is SectionAccess);

To my surprise, the document is opening without entering any USERID and PASSWORD credentials,  What could be the cause for this?

Regards.

[maxgro]

Did you check in menu --> Settings --> Document Properties --> Opening tab

Initial data reduction............

?

Remember to make a backup of the .qvw before using the section access.

[Anonymous]

Many thanks Maxgro.  The settings are in place as per the following screen shot:

Regards

[maxgro]

could you post the .qvw or a small example?

[Anonymous]

Maxgro

Please find attached sample application

[PradeepReddy]

it seems the bellow fields are not existing in your application but using in Section access

     PATENTS,      FDA,    GENERICS,     SHOPPING,     PLAZA_ANALYTICS

[PradeepReddy]

Hope your are providing the sheet level security based on the specific group.

please see the attachment for more info on section access...

[tresesco]

Could you share your SectionAccess.xlsx  or at least a sample screen shot?

[sasikanth]

HI,

Might be the load of SectionAccess.xlsx table filed

[maxgro]

and I also suggest to start

- without binary load

- with one field in the section access table (  _VIEWGROUP)