Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Can I select the Excel version to use?

I have Excel 2007 and 2010 installed on my PC but when exporting data to Excel, QV always creates an xls file and opens Excel 2007.  Is there any way to force it to create an xlsx file and open Excel 2010 instead?  I am running QV version 10.

Tags (3)
3 Replies
rsvebeck
Not applicable

Re: Can I select the Excel version to use?

Hi. Interested in if you got any progress in this. I would also prefer an option where and XLSX is created instead of XLS. Regards, Robert

Not applicable

Re: Can I select the Excel version to use?

No we had to get users to decide which version of Excel they were going to run and then uninstall the other copy.

erich_shiino
Not applicable

Re: Can I select the Excel version to use?

Even if you have only Excel 2007, Qv exports a .xls file, doesn't it?

You control it only if you use macro, but it is much more complicated to manage ( requires special permissions, may not work on Ajax and so on)

Regards,

Erich