Excel File Corruption Error in Alteryx Workflow

[mahapreetha_12030611]

In Alteryx, I used an input data tool to import an Excel file .xlsm format containing multiple sheets. In the output data tool, I used the same file and added a new sheet to store the results of the applied logic. when I ran the workflow, I encountered an error indicating that the excel file is corrupt.

Can you please help me to resolve this?

[binuacs]

@mahapreetha_12030611 you need to use the Block Until Done tool just before the output tool if your input and output are same file

[mahapreetha_12030611]

Hi,

After using Block until done tool , while opening the excel the same corruption issue exists. 

[flying008]

Hi, @mahapreetha_12030611 

1- What version are you using ?

2- Could you please upload same .xslx file for test as above ?

[GGGDias]

IF AMP is enabled, it could be causing the issues even if you are using the block until done tool, depending on your Alteryx version.

So, do use the block until done, and make sure you disable the AMP while outputting to Excel.

Also, make sure you add 1 block until done tool just BEFORE each EXCEL output tool and NOT just one block until done with each of its output going into separate sheets.  It's unintuitive like that.