Writing to Workbook, Block until done, still getting error unable to open file for write

[wonka1234]

hi all,

is there anything else that can be done to write to the same excel file (multiple tabs)?

all my excel output are pointing to different sheets.

Thanks

[rzdodson]

@wonka1234 what are your AMP settings set to? Typically, when using BUD tools, you're going to want to turn AMP Engine off so that it sequences outputs one-by-one.

[cjaneczko]

What is the error you are receiving? Are you saving this to a drive that One Drive is backing up? I have had issues where OneDrive starts to backup the file once the first tab is saved. Try pausing OneDrive syncing and see if that resolves the error.

[wonka1234]

@cjaneczko  error msg - Error: Output Data (47): Unable to open file for write: {Path}\Output.xlsx - Can't open file: {Path}\Output.xlsx: The process cannot access the file because it is being used by another process. (32)

its saving to a network drive.

@rzdodson i do not have AMP Engine checked at all!

[apathetichell]

this is going to sound weird - but alteryx processes top down/left-right. so reposition your tools so the tool further up in the canvas so the the first option in your BUD  if further up in your canvas- and your second option is further down. I'd also recommend adding a few BUDs feeding into the output data tool connected to 2 in your BUD. This is a solo output data - but follows a slew of additional BUDs after output 1. The additional BUDs could create timing issues.