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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.

Deal gracefully with locked excel files

Currently - if someone has accidentally kept an excel file open on their desktop, Alteryx will fail to load this flow.

 

However, it would make more sense to open this file without read-lock as a dirty-read (equivalent of "Read Uncommtted").

This may require some interaction with Microsoft but would be worth pursuing because it prevents / eliminates an entire category of needless canvas errors.

7 Comments

+1Star!

 

As a workaround, we've started using the run command tool and xcopy to duplicate our inputs before running a workflow to avoid these errors.

Aurora
Aurora

it's a good idea @BrianCalvanese - in our server environment we've locked down the use of the run command because of the potential to do damage (either maliciously or deliberately), but this definitely is a way round the file locking issue if you don't have this constraint.

Asteroid

We struggle with this a lot. We use Tableau and Alteryx for different purposes but sometimes use the same source data in an excel file.

 

Tableau works well with opened excel file and even reflects the changes being made on refreshing while alteryx throws an error on re running (refreshing) the workflow.

 

Every time save & close the excel to see if the workflow works is a huge annoyance and energy drainer.. 

 

Alteryx
Alteryx
Status changed to: Partner Dependent

This is a limitation on the Excel side, but we will explore whether or not there are better ways to handle it.

Bolide

 Is there a plan or timeline to work with Microsoft to implement this enhancement?

Meteor

@AlexP     Understand the dependency , we get reported  a lot of user  issues due to the locked excel files. A potential fix would be greatly beneficial to our team.

Atom

I confirm the problems with Excel files.
File is closed but there is some latence in Alteryx reading on the file.

Some Excel writing corrupt the Excel File...