Problem while exporting the pivot table to excel

[#1]

Hi,

   Working with the pivot table, Table it contains 313 columns when exporting it's coming only 256 columns.

   Please help if you having any solution. For your info i am using qlikview version9 and Excle version 2010.

Regards,

Santhosh G

[Gysbert_Wassenaar]

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.

[#3]

Ok Thanks. is there anyway to export all columns.

[Gysbert_Wassenaar]

Yes, as I told you, export to csv: Comma Delimited (*.csv, *.txt). You can then open the csv file in Excel 2010.

[#5]

But we don't have default option called export to CSV. How can we export it.

You mean to say write an external macro.

[Gysbert_Wassenaar · Accepted solution]

Right click the pivot table, choose Export...

[#7]

Thanks. It works.