topic Password Protected Excel in QlikView https://community.qlik.com/t5/QlikView/Password-Protected-Excel/m-p/541771#M692360 <HTML><HEAD></HEAD><BODY><P>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.</P><P>I founda&nbsp; 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:</P><P></P><P>Connection Test Failed</P><P>SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application</P><P></P><P>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?</P><P></P><P><IMG __jive_id="44767" class="jive-image" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/44767_Capture.PNG" /></P></BODY></HTML> Tue, 30 Jul 2013 20:47:09 GMT MalcolmCICWF 2013-07-30T20:47:09Z Password Protected Excel https://community.qlik.com/t5/QlikView/Password-Protected-Excel/m-p/541771#M692360 <HTML><HEAD></HEAD><BODY><P>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.</P><P>I founda&nbsp; 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:</P><P></P><P>Connection Test Failed</P><P>SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application</P><P></P><P>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?</P><P></P><P><IMG __jive_id="44767" class="jive-image" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/44767_Capture.PNG" /></P></BODY></HTML> Tue, 30 Jul 2013 20:47:09 GMT https://community.qlik.com/t5/QlikView/Password-Protected-Excel/m-p/541771#M692360 MalcolmCICWF 2013-07-30T20:47:09Z