Unable to create backup of C:\XXX , xxx.xlsx.bak: Access is denied

[187]

Hi Alteryx Engineer, 

I met this issue when I flush data cell by cell into one excel file. the cell no is not consecutive, this is a known issue, right?

any turn around? (Not able to read the content of the consecutive cell cause the content of it is Fomulas)

[FinnCharlton]

Hi @187 , this issue happens when you have multiple Output Data tools trying to write to the same file simultaneously.

I've seen this issue solved by enabling the AMP engine under Runtime > Use AMP Engine.

Otherwise, I would use Block Until Done tools to control the order of data flow in your workflow. Have a read of these resources and threads to understand this tool and how it can be used here:

https://help.alteryx.com/20231/designer/block-until-done-tool

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Unable-to-create-backup-error/...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Can-t-write-access-excel-files...

Hope this helps1

[187]

@FinnCharlton 

Actually this is not working as expected.

at my scenario, it is not multiple output tool to same file, it is  multiple rows with different cell range and value into a batch macro and flush data is happened at that macro