This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Having similar issue with these two consecutive Excel error prompts. I am running a routine workflow therefore overwriting .xlsx output file. When I choose to create a new sheet I avoid the prompt. I would prefer to overwrite the sheet but want to avoid possible errors/issues and ensure my output values are correct.
@Alteryx, any solution, please? This thread is opened for year and a half with the "solution" being a hot-fix macro created by a user.
UPD: in my case it's the same issue as jacqgeek had: I write in tabs and SheetName is limited to 31 symbols for xlsx. I've added one more module creating a SheetName column with truncated strings in my data and put it just before the output module.
IMHO, this should be integrated into the output module by Alteryx team.
Hey, everyone. I'm having the same problem, but I have another solution to offer. For anyone that wasn't aware, an xlsx and xlsm file is just a zip file of XML documents that define the Excel Workbook. Alteryx is using this to output data to these formats without having to automate and Excel.exe object. It seems like updating the calcChain.xml part of the file is an oversight on their part.
Follow this procedure to prepare any templates you are dumping data into and it will temporarily resolve the problem until you have to open and edit the template again using Excel. This means that you are ok to keep using Alteryx to dump to the same file without worries. I am not able to upload any screenshots due to my firewall at work.
Open the xlsx or xlsm file using your zip file editor. I use 7-zip. You may have to temporarily rename the Excel file into a zip.
In the root directory, edit the [Content_Types].xml file. There will be an entry for "<Override PartName="/xl/calcChain.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.calcChain+xml"/>" Delete this part of the XML document. Save and replace it in the zip.
Inside the zip document, go into the xl subdirectory and delete the calcChain.xml file.
You're done. Rename back to xlsx or xlsm if you had to rename it.
Now you can use this to output data from Alteryx without the file repair popping up. From what I can tell, there are no drawbacks to removing the calcChain. It is an optional part of the file defined in the SpreadsheetML specification (last paragraph) so it doesn't have to be calculated later. Formulas continue to work correctly in my test.