Forum Discussion
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...
- Peter WangIron ContributorOK, 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 WangIron 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 TwohigIron 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.