Output Excel File Error Repaired XML

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!

Error Message

Accepted answers

mberg2512

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.

All comments

mberg2512

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.

bconnors05

I was having a similar issue, but slightly different excel file repair warning when using the reporting tools. Tried the other listed solutions but none solved the problem. The error was limited to a particular sheet in my case, and it was the sheet with the largest number of data columns. The solution that finally removed the error was in the Render tool. In Report style, I increased the Report Style:Paper Size to Tabloid (11" x 17") and my excel output no longer needed to be repaired when opening.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703