topic Can't load Excel Spreadsheet due to access in QlikView https://community.qlik.com/t5/QlikView/Can-t-load-Excel-Spreadsheet-due-to-access/m-p/382453#M1168427 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I've been searching the forums for an answer to this, but couldn't find one anywhere. I've got a spreadsheet to load into a QlikView dashboard which is held on a different server. I can reload the dashboard locally, but when I instruct the QlikView redistribution server to reload and distribute the dashboard, it will not work. </P><P></P><P>If I use a copy of the spreadsheet on my local machine, I don't have an issue. I suspect it's something to do with user privileges and that the server doesn't have acces to this spreadsheet on the other server.</P><P></P><P>Is there anyway in QlikView to set the Windows authentication to use during a distribution or even the importing of the spreadsheet (in the LOAD...FROM statement)?</P><P></P><P>Cheers!</P></BODY></HTML> Thu, 30 Aug 2012 14:36:55 GMT 2012-08-30T14:36:55Z Can't load Excel Spreadsheet due to access https://community.qlik.com/t5/QlikView/Can-t-load-Excel-Spreadsheet-due-to-access/m-p/382453#M1168427 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I've been searching the forums for an answer to this, but couldn't find one anywhere. I've got a spreadsheet to load into a QlikView dashboard which is held on a different server. I can reload the dashboard locally, but when I instruct the QlikView redistribution server to reload and distribute the dashboard, it will not work. </P><P></P><P>If I use a copy of the spreadsheet on my local machine, I don't have an issue. I suspect it's something to do with user privileges and that the server doesn't have acces to this spreadsheet on the other server.</P><P></P><P>Is there anyway in QlikView to set the Windows authentication to use during a distribution or even the importing of the spreadsheet (in the LOAD...FROM statement)?</P><P></P><P>Cheers!</P></BODY></HTML> Thu, 30 Aug 2012 14:36:55 GMT https://community.qlik.com/t5/QlikView/Can-t-load-Excel-Spreadsheet-due-to-access/m-p/382453#M1168427 2012-08-30T14:36:55Z Re: Can't load Excel Spreadsheet due to access https://community.qlik.com/t5/QlikView/Can-t-load-Excel-Spreadsheet-due-to-access/m-p/382454#M1168428 <HTML><HEAD></HEAD><BODY><P>My solution was to use a Windows event to copy down the spreadsheet from the other server to the local machine every morning, and use the copy. This resolved the issue without QlikView's intervention.</P></BODY></HTML> Tue, 18 Sep 2012 08:53:43 GMT https://community.qlik.com/t5/QlikView/Can-t-load-Excel-Spreadsheet-due-to-access/m-p/382454#M1168428 2012-09-18T08:53:43Z