Option to save Office files to local drive first, then sync to Sharepoint / OneDrive
Currently, the default "Save" syncs the file to Sharepoint / OneDrive, then syncs from the cloud back to the local drive. This is a bad sequence, as, if there is a problem uploading and the file cannot be synced, the file is then completely lost. This feature can be manually overridden by going to "File," "Save As," and selecting "This PC," but must be done every time. Besides risking loss of data, by syncing to Sharepoint/OneDrive first, it locks up the file from being able to be used. If the file were simply saved locally first (which is fast), the document could be released for editing while the local file syncs to the cloud, which is exactly how Dropbox works.
Please consider this as part of the "Options" for the sequence for saving files, i.e., "Save to local drive first, then sync to cloud," or "Save to cloud first, then sync to local drive."
Thanks for listening. I'm working on a critical document and cannot afford for versions to be lost because of a bad cloud sync.
Lora Premo commented
I agree a billion percent. You guys have been doing this stuff for so many years, why don't you ever do any user testing? The retrogressive **** you put out is amazing. This is a HUGE inconvenience and with my set up, I HAVE TO SAVE LOCALLY FIRST because Sharepoint likes to eat our files.......
Yes please 100% agree.
I have also lost a lot of data due to this issue. If using collaborative editing, it introduces a big risk of files being overwritten, esp if your connection is slow. I have no idea why you would implement it this way, it makes no sense to me. Save to PC first, then upload makes way more sense. This is how Google docs works and probably why it is way faster and more reliable!
Has this saving process been improved?
I am dealing with users who have files disappear regularly.
The files show in recent items of PowerPoint, they show in the blackberry workspace online, but DO NOT SHOW in the file location on the laptop, but the recent link still opens the document when it is selected. Even after refreshes, updates and syncing, the file still doesn't show
The logical flow is to save docs to the PC first then let OneDrive (on its own time & schedule) sync only those files that have been changed since its last sync. Most efficient use of everyone's time & resources. To assume that everyone always has internet access is stupid. If I want to work on a document on a plane or anywhere there isn't secure internet access, I want immediate access to my files. Give customers a choice instead of taking away a feature that worked well for ages. Should be an easy fix since it used to work this way.
This should be the standard setting!
Hard to understand why it STILL is not implemented!
George W Hennessy commented
Agree+++++; I have lost multiple files the last several weeks due to this HORRIBLE FEATURE!
Can this be dont quickly Microsoft?
Nighmare on the Train.
I was running into this issue and lost notes I took during a meeting. I believe Andrew's response below has solved it (although I now need to manually save rather than count on the "Auto Save" feature). It's a shame it's so hidden and feels like a work around...
Support and agree! And as it takes forever to sync back to my computer, I end up saving 100's of copies, because I cannot find the document in my library/pc!
Frank B commented
Thanks Martin for this post.
That's exactly the problem of today's realization and saving order in Sharepoint/OneDrive.
When opening a Sharepoint-synced file locally from the PC, incl. from the local OneDrive folder and then saving it again, the system doesn't save it to the originial local location and thereafter syncing it with Sharepoint in the background.
Instead, the system changes the file location path to sharepoint and first wants to save the file in Sharepoint and then afterwards syncing it to the local folder on the PC.
This is slow and very risky and from my point of view even unlogic.
The principle of any open/save transaction from my point of view should be, that the system in first order tries to save the file on the location where it was opened from, selecting this file location and path automatically for saving first. This principle should also be applied for any local file, that is set to be synced with Sharepoint.
At least the user should have the possibility to determine the saving priority and sequence in the settings. Thank you very much for considering this in your next update.
I just got a new computer, twice as fast as my old one, and Office is now half as fast as what I had -- because I decided to use OneDrive. I guess I'm getting rid of OneDrive (not seeing the Office devs doing anything about this anytime soon)...
Jean-Yves Duriaux commented
Useless to work with word, excel or ppt if you don´t have an incredible connection. Everywhere I go except university I have troubles and I have lost so much time fighting with crashes and useless waiting beacause of this issue. I need to constantly be going back and forth between csv and xls (every few minutes) and now has become a torture.
Fix this quick. Save into my computer and then back up in the background. Don´t waste my time.
I i is frustrating to do all this. A monopoly will always be a monopoly and that is the caso of MS Offce, I have spent the whole day looking for my stuff both in the hard drive and in One Drive, MS is forcing you to relay on them, it is strange that in a country that is supposed to be the king of competting we are being manipulated to use the product. I am fed up also with the constant explores proposition as my web browser I DO NOT WANT IT cant you undersantd it? I am trapped by a monopoly
Couldn't agree more. Come on guys, we're only asking for an option. Don't assume everybody has Ultra-fast broadband or, indeed, that they want a period where their files *only* exist in the cloud. Save locally first, then sync.
Depending on whether you need 'real-time' collaboration, you have an option to disable this 'feature' from within the OneDrive client. If you launch 'OneDrive' app, then Settings, and go into the 'Office' Tab, and remove the checkmark for 'Use Office 2016 to sync Office files that I open', your system will default to saving the file locally. Once saved, OneDrive sync will upload to the server.
After getting fed up of OneDrive resyncing a 50MB (that's ever getting larger) Excel file - which I regularly work on - from scratch every time I saved, often causing me a delay of many dozens of minutes during my slow home internet connection before I could shut down, and making it difficult to work at cafes or use hotspot, I decided on the following workaround. On Windows Explorer, you can access a local only folder if you go to view > navigation panes > libraries. Under libraries there is a Documents folder, under which there are two Documents folders: your regular auto-sync-to-OneDrive folder, and another hidden one, which does no syncing. I now save the file to this local folder by default, and will copy the file to my OneDrive folder as my back up when I have the time, or when I'm at a superfast internet place like the library. The problem before was when I shut my computer down before syncing finished, I'd end up with a mess of recovered files, risk of lost data, duplication, having to rename and delete duplicates and all that rubbish. Moreover, syncing on a slow connection made the internet unusable for any other activity including basic web browsing (i.e. demolished download speeds), which is also unfair on anyone else using the network at home. So now, for large files at least, I basically use OneDrive as a soft external hardrive, backing up regularly, rather than constantly. It's not too much of a hassle to copy the file over, although I make sure to rename it to avoid confusion.
Olle B commented
Note the workaround described in link below is a solution, but not of the level I would expect from microsoft...manually shifting files? Temporarily pausing OneDrive? Come on guys....
Olle B commented
Agreed - this is a terrible design choice for customers with poor connections...incredibly frustrating to have to wait for a file to upload. Please offer the save-local-first-by-default option