Append data to an open shared excel file

[johnstok]

Hoping for some help!

I have a file which is shared with multiple other users and will be quite difficult to have everyone save and close at the one time.  I'm looking to see if it's possible to update the data and append to the file if it's still open by other users?

Thanks

[Yoshiro_Fujimori · Accepted solution]

Hi @johnstok ,

Alteryx cannot open the file which is exlusively opened by another user (or even by yourself).

As an alternative, you may prepare a file to append, and run a workflow at night (or when others are not using)
which will "union" the shared file with your append file and replace it with the original one.

I hope this helps.