Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Stripping Conditional Formatting in Excel

Jessi_Ortega
6 - Meteoroid

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.

4 REPLIES 4
aatalai
15 - Aurora

Could be with the output keep formatting option

Jessi_Ortega
6 - Meteoroid

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).

cjaneczko
13 - Pulsar

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

O_G
5 - Atom

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.

Labels
Top Solution Authors