I know this has been asked before but for some reason the solutions have not been working great for me. I have multiple data sets that I am trying to output into Sheet 1/Sheet 2/Sheet 3 of one single excel file (on a company network drive). I am getting the error "Can't open file: XX_FILE_PATH The process cannot access the file because it is being used by another process. (32).
For 1.5 years I never got any errors with these workflows then suddenly almost all of my workflows started getting the same message recently. I tried using a parallel block until done tool, but that does not seem to do anything, and I still get the same error.
I also tried "unioning" all of the data together so I could use the normal "block until done" tool (nested for 6 excel sheets), and the block until done also does not seem to work and I still get the same error.
I am wondering if anyone else has had this same issue where block until done / parallel block until done tools do not work for excel outputs, and if anyone has been able to find a way around this. Or if there is something bugging out on my end. The error happens when running both locally on my desktop and also when run on the gallery. Thank you!
