Microsoft Excel 97-2003 Worksheets to *.xlsx files

[vmirand]

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.

[Carolyn · Accepted solution]

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"

Output Tool set to .xlsx

Final Output as xls, not xlsx

[caltang]

Yes, do be mindful of your extensions!

[vmirand]

You are correct! Thank you much Carolyn!