topic Problem with pivot table when export to Excel in QlikView https://community.qlik.com/t5/QlikView/Problem-with-pivot-table-when-export-to-Excel/m-p/385611#M143998 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>im working with pivot table and i need to export Excel. <SPAN id="result_box" lang="en"><SPAN class="hps">While</SPAN> <SPAN class="hps">exports</SPAN> <SPAN class="hps">to a limited extent</SPAN>, <SPAN class="hps">but</SPAN> <SPAN class="hps">when you pass</SPAN> <SPAN class="hps">a certain</SPAN> <SPAN class="hps">number</SPAN> <SPAN class="hps">of columns</SPAN>, <SPAN class="hps">exports</SPAN> <SPAN class="hps">comma separated</SPAN> <SPAN class="hps">data. Ej. I have 14 dimensions and 1 Expression and works fine, but when add a dimension, export comma separated data.</SPAN></SPAN></P><P></P><P><SPAN lang="en"><SPAN class="hps">Any sugestion?</SPAN></SPAN></P><P></P><P><SPAN lang="en"><SPAN class="hps">Thanks<BR /></SPAN></SPAN></P></BODY></HTML> Wed, 30 Jan 2013 14:38:16 GMT julian_ortiz 2013-01-30T14:38:16Z Problem with pivot table when export to Excel https://community.qlik.com/t5/QlikView/Problem-with-pivot-table-when-export-to-Excel/m-p/385611#M143998 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>im working with pivot table and i need to export Excel. <SPAN id="result_box" lang="en"><SPAN class="hps">While</SPAN> <SPAN class="hps">exports</SPAN> <SPAN class="hps">to a limited extent</SPAN>, <SPAN class="hps">but</SPAN> <SPAN class="hps">when you pass</SPAN> <SPAN class="hps">a certain</SPAN> <SPAN class="hps">number</SPAN> <SPAN class="hps">of columns</SPAN>, <SPAN class="hps">exports</SPAN> <SPAN class="hps">comma separated</SPAN> <SPAN class="hps">data. Ej. I have 14 dimensions and 1 Expression and works fine, but when add a dimension, export comma separated data.</SPAN></SPAN></P><P></P><P><SPAN lang="en"><SPAN class="hps">Any sugestion?</SPAN></SPAN></P><P></P><P><SPAN lang="en"><SPAN class="hps">Thanks<BR /></SPAN></SPAN></P></BODY></HTML> Wed, 30 Jan 2013 14:38:16 GMT https://community.qlik.com/t5/QlikView/Problem-with-pivot-table-when-export-to-Excel/m-p/385611#M143998 julian_ortiz 2013-01-30T14:38:16Z Re: Problem with pivot table when export to Excel https://community.qlik.com/t5/QlikView/Problem-with-pivot-table-when-export-to-Excel/m-p/385612#M143999 <HTML><HEAD></HEAD><BODY><P>I think that's because of backward compatibility with older excel versions that can only handle 256 columns. If your pivot table exceeds this number the export format will change to csv.</P></BODY></HTML> Wed, 30 Jan 2013 15:14:27 GMT https://community.qlik.com/t5/QlikView/Problem-with-pivot-table-when-export-to-Excel/m-p/385612#M143999 Gysbert_Wassenaar 2013-01-30T15:14:27Z