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 have a workflow where I use a dynamic input to open numerous single .xls sheets. It works fine.
I want to use a parallel workflow where I again use the dynamic input tool, but to open other worksheets in the same set of files as the first query above. I changed the path to get to the wanted sheets and made sure the syntax is exactly the same as the first query, but I get an Access Database Engine error message telling me the files cannot be found.
Excel wouldn't allow you to access the same file multiple times so if those two branches run in parallel and one of them accesses Sheet 1 from File 1 and the other will attempt Sheet 2 from File 1, it will fail as the file will be "locked". I'd expect to see a different error message but in scenarios like this I make sure the processes get executed one after another rather than in parallel.