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?
