Slow macros when folder is synchronized with OneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-1111769%22%20slang%3D%22en-US%22%3ESlow%20macros%20when%20folder%20is%20synchronized%20with%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1111769%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20following%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20run%20a%20macro%20on%20an%20Excel%20file%20whose%20location%20is%20NOT%20in%20a%20folder%20synchronized%20with%20OneDrive%2C%20it%20runs%20fast%2C%20as%20expected%20(a%20second%20or%20two).%26nbsp%3B%20If%20I%20take%20that%20same%20file%20and%20save%20it%20in%20a%20folder%20that%20IS%20synchronized%20with%20OneDrive%2C%20it%20runs%20significantly%20slower%2C%20say%20ten%20times%20slower%20(a%20few%20seconds%20vs.%20a%20minute).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20known%20issues%2C%20workarounds%20or%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ER%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1111769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1112027%22%20slang%3D%22en-US%22%3ERE%3A%20Slow%20macros%20when%20folder%20is%20synchronized%20with%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1112027%22%20slang%3D%22en-US%22%3EWhat%20happens%20when%20you%20pause%20OneDrive%20and%20then%20run%20your%20macro%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116415%22%20slang%3D%22en-US%22%3ERE%3A%20Slow%20macros%20when%20folder%20is%20synchronized%20with%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20seem%20to%20reproduce%20the%20%22fast%2Fnormal%22%20macro%20execution%20any%20more.%26nbsp%3B%20I%20have%20tried%20uninstalling%20OneDrive%2C%20so%20something%20else%20is%20at%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegardless%2C%20any%20suggestions%20of%20what%20may%20be%20going%20on%2C%20or%20where%20to%20look%20are%20very%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi Everyone,

 

I have the following issue.

 

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

 

Any known issues, workarounds or suggestions?

 

Many thanks,

 

R

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

@PascalKTeam 

 

I can't seem to reproduce the "fast/normal" macro execution any more.  I have tried uninstalling OneDrive, so something else is at work.

 

Regardless, any suggestions of what may be going on, or where to look are very appreciated.