Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III

Password Protected Excel

I have an Excel sheet being loaded into a Qlikview report. We had to add a password protection due to some issues and I cannot get the report to pull from it anymore.

I founda  thread about setting up the ODBC connection to connect, but I having issues getting this to work as explain. I keep getting the message when I got the the select wizard:

Connection Test Failed

SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

I set the below ODBC up and pointed to the workbook, I have the report open prior as suggested in the posts I read and I am using Excel 2007. Am I not setting the initial ODBC up correctly?

Capture.PNG

0 Replies