Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need to use excel doc like source of data for QS app, but I need this excel doc is locked with password, because I must be sure that someone will not change the data...
But if I lock this doc, I cannot reload app with this...
What can I do?
Thanks anyway
Jasmina
Password protected files are not supported by Qlik Sense, so you need to remove password protection from the spreadsheet before loading it into Qlik Sense.
Hi Jasmina,
I suggest you to set the file's attributes set to read-only (right click and select properties -> tick read-only).
G.
But I don't need read-only, because some user will change something from time to time....
But others should not! And I am afraid someone can make that, I make big wrong.
Thanks
Is the entire workbook protected or just individual sheets?
I think Sense should be able to read protected Excel sheets.
Password protected files are not supported by Qlik Sense, so you need to remove password protection from the spreadsheet before loading it into Qlik Sense.
If there is a write-lock applied the document is read-only and no user without this write-password could change the document whereby I'm not sure if Sense could handle this kind of lock by a normal flat-file load.
Beside this there are ways to load a protected excel. I think the following will be helpful for you:
Re: QlikSense-How to load password protected file
Passing userid and password to ODBC Connection
- Marcus
Did you try this? Re: load a Password protected Excel File to QlikView
Uhh guys, this is a challenge
I must see what you have written me....
Thanks