Output EXCEL Template problems

Question

Hello Everyone,

I am facing an error when I am trying to generate a set of date on a specific excel sheet.

You can find attached the Data set that I am using and I am trying to generate this info on the template(Sheet Part II). Please take in consideration that the sheet is protected and nothing can be changed. Also Col C it has a condition with 2 possible variables. When I am trying to generate the data on it I am receiving the following error  for the FIRST RUN(I renamed the file to Template):

On the second RUN is working, but is changing the template:

My output settings:

Any suggestion how can I solve this problem?

Thank you in advance!

DATA.xlsx

Template.xlsx

mihaicom20 · Answer

The last option would be to create a new sheet.

The problem is: even if I try to generate 2 columns (Ex: A and B)  that doesn't contain conditional formatting, I get the same error.

flying008 · Answer

Hi,@mihaicom20

1- if you overwrite sheet or range, the condition validation format can't retain in cell. even select the option of preserve formatting on overwrite.

2- maybe you can 'create new sheet' like sheet name 'Import' in workbook, and Alteryx output data to it. then set the formula in sheet 'Part II' to reference cell value in 'Import' , so your condition format always exist by modify workbook structure.

Qiu · Answer

@mihaicom20 
I have also replicated the problem you encountered.
Hope someoen can propose a solution for it.