OneDrive Synchronisation is locking xlsx file

Question

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 Answer

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).