SOLVED

OneDrive Files slow to load when opening from Excel/Word.

%3CLINGO-SUB%20id%3D%22lingo-sub-309183%22%20slang%3D%22en-US%22%3EOneDrive%20Files%20slow%20to%20load%20when%20opening%20from%20Excel%2FWord.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309183%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20user%20who%20is%20has%20come%20across%20something%20I%20can't%20figure%20out.%26nbsp%3B%20When%20using%20Excel%2FWord%20and%20Selects%20Open%20%26gt%3B%20Browse%20Computer%2C%20and%20clicks%20on%20OneDrive%20for%20Business%2C%20the%20files%20and%20folders%20slowly%20populate%20in%20small%20batches.%26nbsp%3B%20It%20probably%20takes%2020-30%20seconds%20each%20time%20for%20OneDrive%20to%20fully%20populate.%26nbsp%3B%20If%20she%20opens%20File%20Explorer%20and%20then%20opens%20OneDrive%20for%20Business%20in%20the%20same%20manner%2C%20the%20files%20and%20folders%20are%20available%20immediately.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309183%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWord%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312617%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Files%20slow%20to%20load%20when%20opening%20from%20Excel%2FWord.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312617%22%20slang%3D%22en-US%22%3E%3CP%3EI%20believe%20we%20figured%20out%20most%20of%20the%20slowness%20issues.%26nbsp%3B%20At%20a%20closer%20look%2C%20I%20was%20way%20off%20on%20the%20files%20in%20the%20root%20of%20OneDrive.%26nbsp%3B%20This%20person%20had%20close%20to%202700%20files%20at%20the%20root%2C%20not%20including%20folders.%26nbsp%3B%20We%20copied%20all%20of%20those%20files%20into%20a%20folder%20and%20tried%20again.%26nbsp%3B%20It's%20now%20much%20faster%20and%20is%20at%20a%20very%20tolerable%201-2%20seconds%20to%20full%20load%20when%20browsing%20vs.%2020%2B%20seconds.%26nbsp%3B%20I%20appreciate%20all%20of%20the%20suggestions.%26nbsp%3B%20Thanks%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*edit%20-%20typo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309983%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Files%20slow%20to%20load%20when%20opening%20from%20Excel%2FWord.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309983%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20sorry%20everyone%2C%20the%20notification%20e-mails%20for%20replies%20were%20going%20to%20my%20junk%20folder...%26nbsp%3B%20We%20are%20using%20OneDrive%20for%20Business.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20what's%20happening%20is%20when%20the%20user%20is%20in%20Excel%2FWord%2C%20and%20they%20do%20a%20Open%2C%20then%20are%20presented%20with%20a%20list%20of%20default%20locations%20they%20can%20open%20from.%26nbsp%3B%20e.g.%20Recent%2C%20Shared%20with%20Me%2C%20OneDrive%2C%20This%20PC%2C%20Add%20a%20Place%2C%20Browse.%26nbsp%3B%20This%20user%20is%20selecting%20Browse%2C%20which%20then%20opens%20up%20a%20file%20explorer%20view%20window%20and%20she%20then%20clicks%20on%20the%20OneDrive%20-%20OrgName%20folder%20on%20the%20left-hand%20side.%26nbsp%3B%20Once%20clicked%2C%20the%20files%20and%20folders%20stagger%20as%20they%20update%20and%20after%2020-30%20seconds%20it%20fully%20populates.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShe's%20a%20heavy%20OneDrive%20user%20so%20there's%20probably%20100%20folders%20in%20the%20root%20of%20the%20drive%20and%20200%20files%20on%20the%20root%20as%20well.%26nbsp%3B%20Each%20subfolder%20has%20files%20in%20as%20well.%26nbsp%3B%20When%20I%20try%20this%20under%20my%20own%20account%2C%20I%20have%20around%2010%20folders%20and%205%20files%20at%20the%20root%20of%20my%20OneDrive%20folder%20and%20it%20still%20staggers%2C%20but%20only%20takes%20a%20second%20or%20two%20to%20fully%20populate%20everything.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20her%20and%20I%20are%20on%20the%20same%20network%20in%20the%20same%20building.%20I'm%20actually%20on%20WiFi%2C%20but%20she%20is%20hardwired%20at%201Gbps%20link.%26nbsp%3B%20She%20avoids%20the%20web%20method%20of%20OneDrive%20as%20relies%20on%20the%20local%20copy%20of%20the%20files%20on%20the%20hard%20drive.%26nbsp%3B%20Would%20WebDAV%20still%20be%20a%20factor%20if%20using%20the%20File%20Explorer%20(browse)%20method%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20all%20makes%20sense.%26nbsp%3B%20I%20appreciate%20the%20replies%20so%20far.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309341%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Files%20slow%20to%20load%20when%20opening%20from%20Excel%2FWord.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309341%22%20slang%3D%22en-US%22%3EHmm%2C%20yeah..we%E2%80%99ll%20wait%20and%20see%2C%20lol%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309340%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Files%20slow%20to%20load%20when%20opening%20from%20Excel%2FWord.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309340%22%20slang%3D%22en-US%22%3ENa.%20Think%20they%20are%20clicking%20the%20link%20into%20the%20account%20which%20is%20the%20in%20your%20face%20option%20that%20uses%20webdav%20to%20view%20over%20the%20web%20and%20not%20the%20local%20file%20sync%2C%20which%20if%20connectivity%20to%20the%20Microsoft%20data%20center%20isn%E2%80%99t%20ideal%20could%20cause%20issues%20with%20load%20times.%20%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20I%20could%20be%20assuming%20wrong%20as%20well%20%3A)%3C%2Fimg%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309338%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Files%20slow%20to%20load%20when%20opening%20from%20Excel%2FWord.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309338%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%20%2C%20I%20belive%20the%20issue%20was%20happening%20when%20browsing%20the%20local%20computer%20-%20then%20onedrive!%20Or%20did%20I%20misinterpreted%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309335%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Files%20slow%20to%20load%20when%20opening%20from%20Excel%2FWord.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309335%22%20slang%3D%22en-US%22%3EAssuming%20they%20are%20in%20a%20different%20location%20and%20connectivity%20probably%20isn%E2%80%99t%20the%20best%20as%20the%20cause%3F%20Anyway%20when%20using%20the%20onedrive%20link%20in%20office%20it%20goes%20straight%20to%20the%20web%20to%20render%20and%20view%20your%20documents%20instead%20of%20local%20files%20like%20the%20explorer%20method%20does.%20Browsing%20to%20the%20Alocal%20computer%20and%20then%20the%20onedrive%20folder%20in%20office%20would%20alleviate%20the%20issue.%20%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309185%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Files%20slow%20to%20load%20when%20opening%20from%20Excel%2FWord.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309185%22%20slang%3D%22en-US%22%3EWhat%20happens%20if%20she%20uses%20the%20built%20in%20onedrive%20client%20in%20office%20instead%20of%20browsing%20the%20computer%20-%20onedrive%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

I have a user who is has come across something I can't figure out.  When using Excel/Word and Selects Open > Browse Computer, and clicks on OneDrive for Business, the files and folders slowly populate in small batches.  It probably takes 20-30 seconds each time for OneDrive to fully populate.  If she opens File Explorer and then opens OneDrive for Business in the same manner, the files and folders are available immediately.  Any ideas?

 

7 Replies
Highlighted
What happens if she uses the built in onedrive client in office instead of browsing the computer - onedrive?

Adam
Highlighted
Assuming they are in a different location and connectivity probably isn’t the best as the cause? Anyway when using the onedrive link in office it goes straight to the web to render and view your documents instead of local files like the explorer method does. Browsing to the Alocal computer and then the onedrive folder in office would alleviate the issue.
Highlighted
@Chris Webb , I belive the issue was happening when browsing the local computer - then onedrive! Or did I misinterpreted?
Highlighted
Na. Think they are clicking the link into the account which is the in your face option that uses webdav to view over the web and not the local file sync, which if connectivity to the Microsoft data center isn’t ideal could cause issues with load times.

But I could be assuming wrong as well :)

Highlighted
Hmm, yeah..we’ll wait and see, lol
Highlighted

Hi, sorry everyone, the notification e-mails for replies were going to my junk folder...  We are using OneDrive for Business.

 

So what's happening is when the user is in Excel/Word, and they do a Open, then are presented with a list of default locations they can open from.  e.g. Recent, Shared with Me, OneDrive, This PC, Add a Place, Browse.  This user is selecting Browse, which then opens up a file explorer view window and she then clicks on the OneDrive - OrgName folder on the left-hand side.  Once clicked, the files and folders stagger as they update and after 20-30 seconds it fully populates. 

 

She's a heavy OneDrive user so there's probably 100 folders in the root of the drive and 200 files on the root as well.  Each subfolder has files in as well.  When I try this under my own account, I have around 10 folders and 5 files at the root of my OneDrive folder and it still staggers, but only takes a second or two to fully populate everything. 

 

Both her and I are on the same network in the same building. I'm actually on WiFi, but she is hardwired at 1Gbps link.  She avoids the web method of OneDrive as relies on the local copy of the files on the hard drive.  Would WebDAV still be a factor if using the File Explorer (browse) method?

 

Hope that all makes sense.  I appreciate the replies so far.

Highlighted
Best Response confirmed by MomSpaghettiii (New Contributor)
Solution

I believe we figured out most of the slowness issues.  At a closer look, I was way off on the files in the root of OneDrive.  This person had close to 2700 files at the root, not including folders.  We copied all of those files into a folder and tried again.  It's now much faster and is at a very tolerable 1-2 seconds to full load when browsing vs. 20+ seconds.  I appreciate all of the suggestions.  Thanks again.

 

*edit - typo