Output legacy Excel files

I am unable to make any edits to one of my existing workflows after updating to 10.1. I no longer have the file format option of excel legacy so i can not set output option to to delete data and append, any existing tool that was set up with this format errors out when I try to run and if i change it to the overwrite option it errors as well. is there a previous version i can revert to that will bring back the legacy option in my output tools?

Error Message

Output

Accepted answers

MikeB

The Legacy driver we use for Excel is supplied by Microsoft. It was automatically installed with Office 2010, but they stopped including it, so you have to install it manually if your machine has a newer version of Office. Updating Alteryx alone should not have removed this driver.

You can easily re-install it from here:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

NOTE: you should match the driver with your version of Office (32bit driver for 32 bit Office - or 64bit driver if you have 64bit Office)

Once you install the driver you will get the Legacy option back.

I'm curious to know what error you are getting with the new XLSX driver using Overwrite Sheet because that should work for you as well and may be preferable.

All comments

MikeB

You can easily re-install it from here:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

NOTE: you should match the driver with your version of Office (32bit driver for 32 bit Office - or 64bit driver if you have 64bit Office)

Once you install the driver you will get the Legacy option back.

I'm curious to know what error you are getting with the new XLSX driver using Overwrite Sheet because that should work for you as well and may be preferable.

BFritter

Thank you for the quick reponse, we just updated our microsoft office so this was definitely the issue and this was an easy fix. I will pass this on to the rest of my team.

Thank you,

Brian

BFritter

The error I was getting with the new xlsx driver was that the file is currently in use. The workflow is updating 3 sheets in the same excel file and the first tool will update the corresponding sheet correctly but when it gets to the next two output tools they error and say the file is in use. the file is an .xlsm macro enabled file if that matters, (which is why we had to use legacy delete and append when the workflow was created)

JPulley

Hi MikeB,

Is there a driver out there that will work with Office365 32 bit? That's my current version of Office I'm on and would love to have the "Delete Data & Append" feature available on my .xlsx outputs. I just upgraded to Alteryx v2019.3.

Thanks for any help!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703