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.
After Alteryx completes creating/writing an Excel file, the write lock remains and that file can't be read for at least a day until, for some reason, the write lock goes away. Has anyone else found a way to prevent or work around this?
I do understand this might be related to the idea @SeanAdams wrote which unfortunately is dependent on partnership with Microsoft to resolve.
Hi @JoshKushner I'm not sure if this is helpful to you but I'll share that I personally had a lot of trouble with Excel files being locked after write when I was using them to work as databases. For me, it happened intermittently and it was super frustrating. I switched to writing/appending to SQL to make my apps more robust. When I send out Excel files as attachments, I write them dynamically. I haven't had any problems since but I never solved the Excel file locking issue. If you find a solution, please let me know.