Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Problem with Excel export

Hello,

some of our users are reporting that they have trouble exporting data to Excel 2013. The problem is that while exporting Excel hangs in some strange state - I'm attaching the image of the problem.

Any idea what to do?

Thank you!

Best wishes,
MarkoPicture (Device Independent Bitmap) 1 (4).jpg

5 Replies
yousef_am
Contributor II

Re: Problem with Excel export

Maybe number of records is greater than Excel max limit of records.

Not applicable

Re: Problem with Excel export

Hello,

thank you for your answer. Maybe do you know what is the limit in Excel 2013 x86 and in Excel 2013 x64?

Thank you!

Best wishes,
Marko

yousef_am
Contributor II

Re: Problem with Excel export

row limit for Excel 2013 is 1048576

Not applicable

Re: Problem with Excel export

Thank you for your answer. I will check but I'm sure she doesn't have so many rows. Any other idea?

Thank you!

Best wishes,

Marko

mattw3113
New Contributor

Re: Problem with Excel export

We just upgraded to Office 2013 and we're experiencing the same issue as Marko detailed in his original post.  It's not a row limitation issue as it happens regardless of the amount of rows.  We've noticed it only occurs when you already have an existing spreadsheet open.  If you are exporting to Excel and you don't have any Excel files open, it works fine.  We're troubleshooting with our infrastructure team now and will add another post if we're able to resolve it.  Thanks.

Community Browser