Opening Output of Alteryx : Error message

[giadagiordano]

Hello,

I created a workflow that generates an Output.xlsx.

When I open the output.xlsx, there's an error message.

You find attach the error. 

Is there a way to fix the error?
I have to use the output with an RPA, and the RPA (opening the file) read the same error.

Do you know why?

Thank you so much.

[smoskowitz]

HI @giadagiordano --

I've seen this happen when the file you are saving to also contains pivottables. Could it be that?

Thanks,

Seth

[giadagiordano]

No, I don't have pivot table inside!

[PhilippK]

Hi @giadagiordano ,

can you share the data+workflow with me (Alteryx Designer > Options -> Export Workflow) ?

if not - check the following:

- do you write large numeric values? Then check the column size in Alteryx and Excel and extend it if needed.
For example, FixedDecimal Sizes greater than 40.13 will not work in Excel

- is the Excel sheet name too large? Should not be larger then 31 characters. 

- try this solution:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-Excel-error/td-p/49262/page/...

Let me know whether this helped you.

Best regards

Phil