0 Replies Latest reply: Jul 30, 2013 4:47 PM by Jeremy Schmitt RSS

    Password Protected Excel

    Jeremy Schmitt

      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