Slow macros when folder is synchronized with OneDrive

Question

Hi Everyone,&nbsp;I have the following issue.&nbsp;If I run a macro on an Excel file whose location is NOT in a folder synchronized with OneDrive, it runs fast, as expected (a second or two).&nbsp; If I take that same file and save it in a folder that IS synchronized with OneDrive, it runs significantly slower, say ten times slower (a few seconds vs. a minute).&nbsp;Any known issues, workarounds or suggestions?&nbsp;Many thanks,&nbsp;R

pascalkteam · Answer

What happens when you pause OneDrive and then run your macro?

izwebusr · Answer

PascalKTeam&nbsp;&nbsp;I can't seem to reproduce the "fast/normal" macro execution any more.&nbsp; I have tried uninstalling OneDrive, so something else is at work.&nbsp;Regardless, any suggestions of what may be going on, or where to look are very appreciated.

Forum Discussion

Slow macros when folder is synchronized with OneDrive

2 Replies