Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to find a tidy way of loading Data from an Excel protected workbook. I've seen the solution in the link below but cannot get this to work?
load a Password protected Excel File to QlikView
Ive checked command line options and had a play with vba code, opening a documentand trying to save a temp unprotected version but
a) I cannot get it to work
b) want to avoid any vba as it causes difficulties for support?
I am using QV 11.2 SR4 and Excel 2013 on windows 8 (IE 10)
Any ideas?
Thank You?
Hi,
if you can get the dpt. to go along with this, just
- unprotect the workbook as a whole
- protect the individual sheets instead
=> QlikView will then read the file without problems.
Best regards,
DataNibbler
Hi,
if you can get the dpt. to go along with this, just
- unprotect the workbook as a whole
- protect the individual sheets instead
=> QlikView will then read the file without problems.
Best regards,
DataNibbler
Thanks DataNibbler (Love the name!)
Will give this a spin and let you know.
Many Thanks
DataNibbler - This works a treat. Need to do this in conjunction with DataNibblers Answer. (Note there may be a security issue linking to a hidden workbook sheet from another workbook)
Here is what you do in Excel 2003: (variations also work for 2007,10,13)
Once this is done, the sheet is hidden and cannot be unhidden without the password. Make sense?
(Given Excel's backward compatibility, I'm sure you can do this in 2007)
Hi John,
hiding a sheet was not an option in my instance (the dpt. needs the Excel file themselves), but it sure is a good option.
Thanks for sharing this one!
Maybe, if you have time, you could make this last post into a small document and upload that?
Best regards,
DataNibbler
Hello DataNibbler
Not too sure what you would like? Let me have a bit more info and I will do it. Also is there anyway i can mark you as correct answer as opposed to helpful?
Hi John,
I have done it already, don't bother 😉
To mark my answer as correct, you have to unmark it first - and unmark your own answer 😉
Best regards,
DataNibbler
Does VBA Code not work? But it did help me recover the forgotten Excel password. Or you should try copying and pasting an Excel worksheet or uploading it to a Google Sheet to unprotect Excel.