Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading Data from Password Protected Excel Documents

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?

1 Solution

Accepted Solutions
datanibbler
Champion
Champion

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

View solution in original post

7 Replies
datanibbler
Champion
Champion

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

Not applicable
Author

Thanks DataNibbler (Love the name!)

Will give this a spin and let you know.

Many Thanks

Not applicable
Author

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)

  1. In your sheet of interest, go to Format->Sheet->Hide and hide your sheet.
  2. Go to Tools->Protection->Protect Workbook, make sure Structure is selected, and enter your password of choice.

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)

datanibbler
Champion
Champion

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

Not applicable
Author

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?

datanibbler
Champion
Champion

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

SeanMoss
Contributor II
Contributor II

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.