cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Discover peer insights or crowdsource your one of a kind Designer question.

Output to Excel error

SOLVED
Asteroid

I have several workflows that are sending output to an Excel file.  When I open the Excel file I always get a message "We found a problem with some content..." Do you want us to recover as much as we can?...."     I always answer "Yes" and then I get a message about the repairs to the file which always says "Removed Records: Formula from /xl/calcChain.xml part"

 

I have no idea what any of that means.  I'm able to use the excel file, and run the macros in it.  However, I'd like to avoid those messages if I can before I hand these files off to someone else.

Alteryx Certified Partner
Alteryx Certified Partner

@MsBindy,

 

If you simplify the workflow to take data from a text input tool and write it to the output file, you could export (options -> export workflow) and post the yxzp file to the community for us to take a look at.  Macros in the workbook are something that I avoid.  I like a clean xlsx file and am weary of xlsm files.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Asteroid

Thanks...Let me trim it down some.  I'm kind of new to this and have created a monstrosity of a workflow.  I'll try to make a much more simple case.  The reason for the macros in the outputted Excel files is that I'm formatting them to send out to a client.  The reporting tools in Alteryx are currently way above my current skill level. 

Asteroid

@MarqueeCrew;  thanks so much for the help.  Your observation about the behavior of Excel when dropping the sheet prompted me to do a little checking on the Excel side.  I discovered by adding this little bit to programmatically open and repair my Excel file, the errors disappeared;; the file opens clean, and the macros run.

 

Sub Import_Click()

 Application.DisplayAlerts = False

 Workbooks.Open "filepath/filename.xlsm", CorruptLoad:=XlCorruptLoad.xlRepairFile

 End Sub

Alteryx Certified Partner
Alteryx Certified Partner

@MsBindy (Donna),

 

Glad to be of assistance to you.  That code is something that others might benefit from.

 

Keep up the good work and enjoy your alteryx license.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Asteroid

 

I've just received the same error but not in a macro enabled workbook.  Similarly the excel output seems to be ok, is this an issue with Alteryx?

 

Thanks,

Paul

I'm sorry... but THAT might be a remedy, but it is NOT A SOLUTION.  This is a bug in Alteryx and needs to be addressed by ALTERYX.  There is no reason the OUTPUT to an EXCEL MACRO file should have this kind of error.

ALTERYX .... FIX THIS.