Alteryx Overwriting Excel Formatting for missing records

[RichD]

Hi All,

I have searched around on the forum/google and I can't seem to find a discussion addressing this particular issue I am having.  I am hoping the community can point me at a post and/or help me resolve this.

I have an annual report/s I create. In the previous few years, the preserve formatting seems to have worked how i expected (since i started doing this).  I am not sure why it is not working now.  I make some minor adjustments to the workflow, range and output configuration (file path) each year (which might be the culprit), but I have looked at my previous year's workflows and I can't see what I would be doing different.

I have my excel template that looks like this (see image below).  I know I won't exceed 100 rows per report so I have my output set to essentially Range = B1:P101 (everything up to the yellow).  That way every report looks the same.  I have it dynamically read out to the various reports creating a file path that I specify (i.e. <File path>\|||Sheet$B1:P101).  I click on preserve formatting in my output configuration.

Most of the reports might have 10 or 20 records, but I still want the report to have all the same formatting for all 100 rows.  When I run my workflow this is the result... it seems like it is overwriting the area where there are no records by completely eliminating the formatting (Area circled in red).

I don't understand what I am doing different/wrong this year and/or if something has changed with recent releases?  Can someone help me understand how to preserve the are that is not getting data as well?

[NadiaFS]

I have the same issue! I hope someone has a solution :)