Output with Error messgae

[kauser]

Hello, 

After running the workflow when i click on output link i am keep getting this error message on excel. is it something i need to change my workflow or its  MS Excel issue. 

" We found a problem with some content in "File name.xlsx". do you want us to try to recover as much as we can? if you trust the source of this workbook, click Yes." 

please advice. 

thank you 

kauser 

[john_watkins]

Normally I see that when I have an Excel workbook with values that don't match the datatypes.   I've had dates for example that were outside the range of a normal day value for a month.   I'd see if you can detect anything in the workbook, assuming you didn't create the workbook with Alteryx.

[abacon]

I see this issue sometimes when I create a table using the table tool or when it's a huge CSV that is created. Is it a normal output data tool going to xlsx?

[kauser]

yes there is a one CSV input file. so this might cause this issue. 

[john_watkins]

If there are any human entered text fields, make sure that you have your Input tool to ignore characters in quotes.  You can also set it warn on error vs. a hard error.   If you can find any of the text causing the error, try to search for it in the file.  Use the most specific portion to search for.     You are reading a .csv when this happens or writing one?