Forum Discussion

MomSpaghettiii's avatar
MomSpaghettiii
Copper Contributor
Jan 04, 2019

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

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?

 

excel
onedrive
word
  • MomSpaghettiii's avatar
    MomSpaghettiii
    Jan 09, 2019

    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

  • adam deltinger's avatar
    adam deltinger
    MVP
    Jan 04, 2019
    What happens if she uses the built in onedrive client in office instead of browsing the computer - onedrive?

    Adam
  • ChrisWebbTech's avatar
    ChrisWebbTech
    MVP
    Jan 05, 2019
    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.
      • ChrisWebbTech's avatar
        ChrisWebbTech
        MVP
        Jan 06, 2019
        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 🙂

Resources