Microsoft Excel 97-2003 Worksheets to *.xlsx files

Hello Alteryx Community. I was wondering if someone could help out with this inquiry. My workflow is generating Microsoft Excel 97-2003 Worksheet as the output even when the workflow has been set up to produce xlsx files. I also checked on the input files and none are Microsoft Excel 97-2003 Worksheet.

Workflow

Help

Accepted answers

ccanterman

What data do you have in the Vendor Names field? When I use the "Change Entire File Path" option, I'll have a field with "G:\<location info>\<file name>.xlsx|||Sheet1" or something like that. If yours is set up that way, is it possible that it has .xls instead of .xlsx?

Edit: I just tried this out and I could reproduce. When I sent my Formula Tool to be .xls and the Output Tool to be .xlsx, my final output file was still a .xls

Formula Tool which includes "xls", not "xlsx"

Formula Tool.png

Output Tool set to .xlsx

Output Tool.png

Final Output as xls, not xlsx

Output File.png

All comments

ccanterman

Edit: I just tried this out and I could reproduce. When I sent my Formula Tool to be .xls and the Output Tool to be .xlsx, my final output file was still a .xls

Formula Tool which includes "xls", not "xlsx"

Formula Tool.png

Output Tool set to .xlsx

Output Tool.png

Final Output as xls, not xlsx

Output File.png

caltang

Yes, do be mindful of your extensions!

vmirand

You are correct! Thank you much Carolyn!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703