OneDrive Synchronisation is locking xlsx file

[wdtoit]

I have a scenario where I created a dataset, via Alteryx Designer, in Excel on one tab and a summary on another tab. Sometimes, when the dataset is quite large (10MB+), I get an 'file locked by another application' error when Alteryx is trying to add the summary tab. This appears to be when the file, with the large dataset, is synchronising via OneDrive. Has anyone experienced the same and is there a potential workaround? Thanks

[FilipR · Accepted solution]

Ah, good old OneDrive...

The best solution for this would be changing your save path to a place where OneDrive does not have access to. Try with a shared drive (you will need to use it anyway if you want your workflow to run from the Gallery).

[wdtoit]

Thank you. Good suggestion, seeing as was about to promote that to sever!