Output Excel File Error Repaired XML

[mberg2512]

I am writing to an .xlsx file in an Alteryx workflow and I receive the following error: 'We found a problem with some content...Do you want to try to recover as much as we can?' Once I click yes, I then receive this pop up: 'Removed Records: Cell Information from /xl/worksheets/sheet12.xml part'

The current setting is to overwrite the sheet. Alteryx seems to be doing so as the workflow runs correctly. But in Excel, the headers remain and the data below is being removed.

More information: I have a block until done between the different sheets. The other sheets are working correctly.

The same workflow was running fine yesterday. After no changes, it is giving me this error today.

If you need any other details, let me know. Thank you!

[mberg2512 · Accepted solution]

Update: I deleted the tab, created a new one with a different name and changed the output to overwrite that tab and it is working now.

[Wixard]

Wanted to give this a thumbs up - I've been pouring through the forums to find a fix for this frustrating situation. 

This is the only thing that worked!

[phoenix64]

Did I really get this error just because the name of the sheet was lengthy? Alteryx seriously needs to fix this or add an error message for lengthy sheet name 😶

[guth05]

I was getting this same error when using the render tool to create the excel file. I found that it was because I used the report header to dynamically pull in data from a field into the header of excel and the data was too large.  So I changed the font size and that solved it.

[Gfreeman]

What was the actual solution?  I can't find it?  Is it a problem with the Alteryx side?

Greg

[Wixard]

For me it seemed like it was an issue in Excel. The solution was the start from scratch on a new Excel workbook

[mystasz]

I hope this can help something in the future....

I was just having this issue and it seemed to be related to how I was creating the FullPath in the Formula tool, specifically the sheet name.  

Before (errors): "C:\Users\UserID\Box\ + [FileName] + "_Summary" +'.xlsx|||' + "'"+"Record Summary"+"$'"

After (no errors): "C:\Users\userID\Box\" + [FileName] + "_Summary" +'.xlsx|||Record Summary'

[ohnativ001]

I don't know if it's still actual.

1. Try delete sheet and create the same.
2. Try to expand range of your formatting (applicable for templates)

3. Convert your xlsx to zip, then unzip, open xml with your data and find missed tag. Zip all xmls and convert to xlsx.