Forum Discussion

Peter Wang's avatar
Peter Wang
Iron Contributor
Mar 07, 2018

Why save files to OneDrive online by default?

For example, saving an new Excel file to one local folder syncing with OneDrive. Even following these steps:
Save as -> This PC -> More options - > C drive -> Users -> my username folder -> OneDrive - HP -> Save, the status bar in Excel indicates: "uploading to SharePoint". So it seems to be saved online to OneDrive by default instead of offline to the local hard disk first.

That's slower and depends on my network connection. How can I make it to save offline to the local hard disk first then syncing to OneDrive?

According to my searching, it happened years before and solved with an updated OneDrive app. But I'm on 17.005.0107.0008 so it's weird...

https://answers.microsoft.com/en-us/onedrive/forum/odwork-odedit-sdwin8_1/onedrive-stalls-word-by-saving-offline-files-to/a82c3f1f-39f9-48fc-b965-2aed19503fc5

  • Peter Wang's avatar
    Peter Wang
    Iron Contributor
    OK, updating to the latest version of OneDrive didn't work.
    One behavior I noticed is if I set OneDrive to pause syncing for like 2 hours, saving files goes to the folder on the local hard disk first, then resume syncing will be fine.
    • Peter Wang's avatar
      Peter Wang
      Iron Contributor

      Uninstall and reinstall the latest OneDrive Windows app didn't work, either.

      One example, I create a new blank Excel spreadsheet file and save it to one folder on my hard drive. And that folder was set to sync with OneDrive for Business. Unfortunately, the Excel status bar shows: "Uploading to SharePoint...". It's obviously looking for the online location first to save files instead of offline location on the hard drive and it takes more time, of course.

      • John Twohig's avatar
        John Twohig
        Iron Contributor

        Peter

        I am not sure that is the case. I just tried it with a large workbook. I did get the message showing "Uploading to SharePoint" but I was able to close Excel right away.

         

        When I clicked on my OneDrive could it said that it was still uploading it, which is what you would expect if it was saved locally and then synced.

         

        What I didn't expect was that as it showed the progress (1 of 12MB, 2 of 12 MB, etc.) it looked like it was recopying the whole file up to SharePoint. I thought it was supposed to sync only what had changed.

Resources