topic Re: Problem while exporting the pivot table to excel in QlikView https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518176#M193508 <HTML><HEAD></HEAD><BODY><P>Yes, as I told you, export to csv: Comma Delimited (*.csv, *.txt). You can then open the csv file in Excel 2010.</P></BODY></HTML> Thu, 22 Aug 2013 11:23:15 GMT Gysbert_Wassenaar 2013-08-22T11:23:15Z Problem while exporting the pivot table to excel https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518173#M193505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp; Working with the pivot table, Table it contains 313 columns when exporting it's coming only 256 columns.</P><P>&nbsp;&nbsp; Please help if you having any solution. For your info i am using qlikview version9 and Excle version 2010.</P><P></P><P></P><P>Regards,</P><P>Santhosh G</P></BODY></HTML> Thu, 22 Aug 2013 10:54:24 GMT https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518173#M193505 2013-08-22T10:54:24Z Re: Problem while exporting the pivot table to excel https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518174#M193506 <HTML><HEAD></HEAD><BODY><P>You can only export that many columns to an csv file. The biff excel format simply that QV uses for excel exports doesn't support more than 256 columns. In Excel 2010 you should be able to load the csv file with all columns.</P></BODY></HTML> Thu, 22 Aug 2013 11:09:12 GMT https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518174#M193506 Gysbert_Wassenaar 2013-08-22T11:09:12Z Re: Problem while exporting the pivot table to excel https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518175#M193507 <HTML><HEAD></HEAD><BODY><P>Ok Thanks. is there anyway to export all columns.</P></BODY></HTML> Thu, 22 Aug 2013 11:15:44 GMT https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518175#M193507 2013-08-22T11:15:44Z Re: Problem while exporting the pivot table to excel https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518176#M193508 <HTML><HEAD></HEAD><BODY><P>Yes, as I told you, export to csv: Comma Delimited (*.csv, *.txt). You can then open the csv file in Excel 2010.</P></BODY></HTML> Thu, 22 Aug 2013 11:23:15 GMT https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518176#M193508 Gysbert_Wassenaar 2013-08-22T11:23:15Z Re: Problem while exporting the pivot table to excel https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518177#M193509 <HTML><HEAD></HEAD><BODY><P>But we don't have default option called export to CSV. How can we export it.</P><P>You mean to say write an external macro.</P></BODY></HTML> Thu, 22 Aug 2013 11:35:37 GMT https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518177#M193509 2013-08-22T11:35:37Z Re: Problem while exporting the pivot table to excel https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518178#M193510 <HTML><HEAD></HEAD><BODY><P>Right click the pivot table, choose Export... </P></BODY></HTML> Thu, 22 Aug 2013 11:41:31 GMT https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518178#M193510 Gysbert_Wassenaar 2013-08-22T11:41:31Z Re: Problem while exporting the pivot table to excel https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518179#M193511 <HTML><HEAD></HEAD><BODY><P>Thanks. It works.</P></BODY></HTML> Thu, 22 Aug 2013 11:46:18 GMT https://community.qlik.com/t5/QlikView/Problem-while-exporting-the-pivot-table-to-excel/m-p/518179#M193511 2013-08-22T11:46:18Z