community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Output to Excel error

Atom

Is there any update on this? I have the same on 2 of my workflows which is quite painful

Highlighted
Meteoroid

same problem here

Meteoroid

It appears that the solution for my case is to delete all errors in name manager within Excel. Hope it helps.

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.snip.JPG

 

snip2.JPG

 

Atom

I'm having this issue too. 

 

@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.

Meteor

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.

 

  1. 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.
  2. 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.
  3. Inside the zip document, go into the xl subdirectory and delete the calcChain.xml file.
  4. 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.

 

 

Labels