Excel 2010 export - capping at 65K and should not

[#1]

Excel 2010 is installed on a Windows Server 2010 R2 operating system. We are using QlikView 10.0 for 64bit.

The problem is that when one clicks on the "send to excel" icon at the top of a Qlikview pivot table report, the resulting excel output file is capping the data at 65536 records, when in fact there are many more records than that. My understanding is that Excel 2010 should allow 1,048,576 rows and 16,384 columns.

Please advise.

Thanks,

Stephanie Lind

[#2]

uppss..yes i'm sorry..it works..but how about export into xls in the qlikview server?

can we put the same cinfiguration there?

thx

[#3]

i put same config in the server and it works..yipikaye..

[ashfaq_haseeb]

Hi,

If it answer your question,

Then I would suggest you to mark this question as answered.

As it might help others to find the relevant answers.

Regards

ASHFAQ

[#5]

i'm sorry but this is not my question..so i cannot mark as an answer..

thx

[pibarguren]

Hi Ano Milo,

Where in the qmc did you configurate this so it applies to publish apps?

Pamela