Excel file corruption if workbook has pivot tables in it.

[ecapox]

I have a workflow that injects three new tabs into 60 EXISTING excel files. I am using the overwrite tab/range process on output.

After these tabs are injected into the existing Excel spreadsheets, some of the workbooks get corrupted. Upon opening the workbook, Excel attempts to repair the file and in many cases it works. When the message pops up that describes what needed to be repaired, it is always due to pivot tables. If the excel workbook has a pivot table anywhere in it, even if it isn't affected by my tab creation workflow, the file becomes corrupted.

Is this a known bug/issue with adding tabs into Excel spreadsheets? Below is the screenshot of the notification, post repair.

I've tried AMP/Non AMP.

I've tried compatibility mode.

I've tried create new sheet instead of overwrite sheet/range.

[dreldrel]

Hi, I would suggest using a clean temporary sheet for Alteryx to output to. You can then use lookup formulas or a pivot table to pull the values into your main sheet so the pivots continue to function correctly. You can hide those Alteryx sheets from end users if needed