Exporting to Excel - Without Fill Gaps

[#1]

I'm trying to export a table from Qlikview into Excel by clicking the 'XL' button. Works fine, but once in excel it 'fills gaps' for every empty cell in the table to reflect the cell above. Can anyone advise how I stop it from doing this?

Thanks!

Dipen

[Gysbert_Wassenaar · Accepted solution]

The only way to do that without resorting to macros is to right click the pivot table, choose Copy to Clipboard, select Full Table and then open Excel and choose Paste. The Send to Excel option and the XL button send the complete records that are used to display the pivot table to Excel without any formatting.

[calvindk]

An alternative to that if you have users that do this often, is to create your own macro for pivot exporting.

There might be someone who already made one, but that should be searchable.

This will require VBA coding, and that you allow your document to 'use potentially unsafe macros'

[#4]

Also try using the right click on the chart -> Export -> give the name with the extension .xls

this might work.............  Please try it.

[#5]

Thanks all most helpful