This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm using Alteryx as a reporting tool to write to excel files on a shared drive. The problem is that multiple files could be open when the workflow is scheduled to run and it isn't possible to write to open excel files. I've read the prior posts on the matter that recommended either making the files Read-Only or saving them as Excel Legacy. When I've tested both of these options, Alteryx still isn't able to write to the file. When saving to an open Legacy file, I get the error message "You have found a bug. Replicate, then let us know. We shall fix it soon." When it's saved as Read-Only, I get the error "Cannot modify the design of Sheet 1. It is read only." Am I missing something?