Hey experts,
I get the following error while trying to output data to multiple tabs in the same excel spreadsheet.
"..process cannot access the file because it is being used by another process". Note that this error occurs *randomly* after moving the workflow to another network drive and I believe it is because the server is slow. I have read previous posts that have suggested using Parallel Block until Done but I am not sure where to place the tool in my workflow since the data is being output from a single data stream for a given file. Attached is a screenshot of how the workflow looks like at the end. Output File 1 & 2 have multiple tabs with different "accounts". Currently it will write 1 or 2 tabs in the sheet and then throw the error, so the files are not complete. I have tried playing around with the throttle tool, but it takes a long time and I'm not sure if it does the trick. I ahve also checked that the AMP Engine is unchecked. Would appreciate any inputs! TIA!
If not, try this
Hi @Ragini
You can utilize the Block until done tool to output to multiple sheets.
https://help.alteryx.com/20223/designer/block-until-done-tool
Im using a batch macro to write to multiple tabs within a single excel file. And I get an error randomly at times. Could you help me understand why. I have attached a sample macro for this use case.
error message
Error: WriteToTabMacro (96): Record #1: Tool #14: Unable to create backup of Output\TTTT_ALTERYX.xlsx to Output\TTTT_ALTERYX.xlsx.bak: The process cannot access the file because it is being used by another process. (32)