Qlikview Export to Excel Formating is getting lost

[amars]

Hi all,

I need to create a export to excel which will be send to user daily & need a format as shown below

Now I have created a chart in this format in qlikview & have dragged the Dimension's # Of Days and the (Year-Month /Quarter/Year /Remarks all in One in one Dimension) across to show the values grouped by month as well to show the No of days accordingly.

Now while exporting it to excel it is working fine but when Copy To ClipBoard -> Full Table is not working (in macro) for even no of years and the columns near the # Of Days are getting overlapped.

Attached is the file after export.

Please help How can I export

One intresting thing is for the second year it is working fine but not for the First and third year (the same macro).

Please suggest.

Thanks

Amar