8 Replies Latest reply: May 6, 2013 2:03 AM by jeniferlee RSS

    Access Point export large data sets to Excel

    Wendy Wallace

      We have an issue with a client (running QV11 sr1) where users get disconnected when exporting large data sets from Access Point. Their theory is that Qlikview tries to export to Excel 2003 and hits the row limitation. Then it re-runs the query and sends it to an .aspx file that has a much higher row limitation. Because it takes a while to generate, users get disconnected from Access Point.  We are attempting to find a way to alter the behavior and change the default to Excel 2010.

       

      Can anyone tell me the step-by-step process that Qlikview uses to export data to Excel? Does Qlikview generate the spreadsheet on the Client?

       

      We would like to control “where” the file is generated – preferably on the server and then send to the user’s desktop.