Stripping Conditional Formatting in Excel

Question

Hello,

I am running an alteryx script that populates a report. Every now and then when I run the flow, it strips away all the conditional formatting from Excel and I cannot pinpoint why. Sometimes it won't strip it for a whole week but eventually it does. I run it the same way everyday. Once it gets strip , all I do is copy the report from the day before and then run the flow again, that always fixes it after it gets strip. If somebody knows what may be the issue on why it randomly strips the conditional formatting, I would appreciate the knowledge.

O_G · Answer

I am a bit late to this, but just had the same problem which I managed to resolve.

In my case, the problem was that I had a formula that stretched all the way down to the last row in the worksheet. I am not sure why, but when I instead set the formula to only cover the first 10 000 rows (which was more than enough for me) then it started working again.

cjaneczko · Answer

Have you tried using the Blob tool which copies the formatting from a template into the output file?

Jessi_Ortega · Answer

I have the ' Preserve Formatting on Overwrite(Range Required) ' checkbox checked. Sometimes it keeps the formatting and sometimes it doesn't. I've noticed when it keeps the formatting it takes longer (15-20min) versus when it doesnt, the flow runs (5-10 min).