Jan 25 2017 09:18 AM - edited Jan 25 2017 10:42 AM
For years, you have been able to sync your OneDrive (and SharePoint) documents to your PC, which lets you work on the go while still being able to collaborate with others in Office. This integration was powered by the previous generation OneDrive for Business sync client (groove.exe), and we've been working hard to fix issues and improve reliability so the experience is as smooth as possible. With the release of the latest OneDrive sync client (which we refer to as the Next Gen Sync Client or NGSC, we saw an opportunity make the Office sync experience better than ever.
We've now delivered a new integration which combines the rock-solid performance and reliability of OneDrive with the advanced collaboration features of Office 2016. Here's a summary of how the latest OneDrive sync works differently from both competitors and from our previous sync client (groove.exe):
If a document is synced to your machine, Office will never wait to open the server copy. Office opens the locally synced file immediately, and if there are any changes on the server, Office will download those asynchronously. This allows you to open under any network conditions without waiting and is a big advantage over other sync and share services. Due to the partnership between OneDrive and Office, it doesn't matter if the file was opened from Recent Files, File Explorer, clicking a URL, etc. If the file is synced to the device, the synced file opens first.
Similar to how Office opens files, saves start with the locally synced file. After the file saves, Office will upload changes directly to the server. If Office can't upload because the device is offline, you can keep working offline or close the file. Office will continue to save to the locally synced file, and OneDrive will handle the upload once the device gets back online. In this integration, Office works directly with the files that are currently open, enabling co-authoring in Office apps like Word on the desktop, which no competitor offers. For files that are not open in Office, OneDrive handles all syncing. This is the key difference between the old sync client integration and the NGSC, and this lets us achieve co-authoring along with the best performance and sync reliability.
Since the release of Office 2010, files are uploaded to OneDrive via the MS-FSSHTTP protocol. This lets Office avoid uploading the entire file on every save if only a small part has changed. For example, if a PowerPoint presentation has a large video in it, that video won’t be re-uploaded on each save. It is much more efficient than a full file upload, and it again speaks to the tight interoperability between Office and OneDrive.
Some conflicts are unavoidable, and OneDrive gives you control over how these conflicts get resolved. If Office 2016 is not installed, OneDrive will create a second file with the user’s conflicting copy after detecting a conflict. If Office 2016 is installed, users have the option to “Open in Office” to resolve the conflict. This will either automatically merge the conflicting copies or show a merge experience that lets users pick the right version of each conflicting change. Users can choose to duplicate the file instead, or they can disable the “Open in Office” option entirely in the OneDrive settings.
Office 2016 and OneDrive work seamlessly together to keep your files in sync while letting you easily collaborate on your documents and share them with others. This integration provides dramatically improved performance and reliability without sacrificing advanced collaboration features like real-time co-authoring. Now you have a single tool to sync all your OneDrive and SharePoint Online content with the best integration with Office, great performance, and rock-solid sync.
Office integration with the OneDrive Next Generation Sync Client is available now for all Windows releases of Office 2016, and it works for all modern Office document formats (docx, xlsx, pptx, etc) synced by the Next Gen Sync Client. We’re also working to bring this experience to Office 2016 for Mac, though we don’t have a release date to share at this time.
Office integration with NGSC Teamsite sync requires click-to-run build 16.0.7167.2001+ or MSI build 16.0.4432.1000+
Eric O'Brien- Program Manager- OneDrive
Oct 04 2017 03:35 PM
Great stuff!
The only thing I find users get confused with is related to Sync-ing and Excel. They create and Excel (In OneDrive or SharePoint) which has been sync locally. They start adding links between spreadsheets to reference cells and do vlookups as they have always done in previous versions. It added the link at a local reference, ie. c:\..\SharePoint\TeamSite\filename.xlsx, they then say to people start using the spreadsheet thinking that it is referencing https://xxx.sharepoint.com/sites/TeamSite/Shared%20Documents/filename.xlsx and of course it doesn't work.
Perhaps this is an excel thing, but it would be good if this linking/sync worked out the Unique ID of the file and added that link instead. With a criteria that said look for the unique ID locally first and if it can't find it go to the web version. Does this make sense?
Feb 06 2018 08:57 AM
Feb 08 2018 09:58 PM
A) I was under the impression that OneDrive already sync'ed only the parts of a file that had changed, because... efficiency. Does OneDrive (without the Office 2016 integration) actually copy entire files for every little update or change to a file? How often would it be doing this? In the example you describe, with the large video in a PowerPoint file, would OneDrive really upload the entire file every five minutes or so, the whole time you were editing that file if one had this option turned off or if one were using an older version of PowerPoint?
B) Does the Office 2016 program need to be open, with that file open, in order to make these piecemeal synchronizations? Or does enabling this option allow these kinds of piecemeal synchronizations any time after said file has been initially opened by a Office 2016 program?
C) In order to initiate this feature, do I need to open said file from the OneDrive web interface, or do I open it from the OneDrive folder on my hard drive? Or, Is there some way I can indicate, as I am opening or saving a file, regardless of where it is located, that said file should be added to the list of files that are synchronized via OneDrive? None of the documentation is clear on this point. It just says, "Use Office 2016 to sync Office files that I open," but does not say from where. I know, one could assume they mean "from OneDrive" but one never knows. Plus, this leaves seems to leave the user guessing as to which files will be opened in this manner and which won't.
Yes, I know I'm being a little pedantic here. But that is what good technical writing is all about.
Reference:
Feb 16 2018 09:42 AM
If separate users are working on the same file; both Offline; how is the file synced when they return online; at different times.
Feb 16 2018 02:55 PM
Gary,
In the OneDrive settings, you can pick a default on how this is managed.
Mar 06 2018 06:39 AM
Hello Stephen
There is something which is not clear for me.
Is this new tool working with sharepoint libraries hosted on a Sharepoint OnPremise ?
We are using OneDrive for Business (groove) with this, for several years, and we have lot's of problems (conflicts not explainable, librairies that become entirely "red", etc), and often the only solution to make OneDrive working again on a client pc is to clean everything (stop synchronizing each librairies, empty office cache, and recynchronizing all librairies) :o(
I would really appreciate if a new tool without those issues could be used to synchronize our sharepoint onpremise librairies...
Thank you for your feedback
Marc
Mar 06 2018 06:49 AM
Hi
What is the reason why the 'Use Office 2016 to sync Office files that I open' doesn't work? We experience this, and whenever we try to save an offline file, we need to specify a new file name. It is not possible to save the existing file. I have seen that MS has recommended switching this feature off. By doing so, we are able to synchronise. But we lose the confilict resolution feature and instead a new file is created in SharePoint. Have you been able to find out why this is a problem?
Regards
Tore
Mar 19 2018 01:34 PM
A coworker and I are having trouble getting co-authoring to work for an Excel workbook saved in a SharePoint Online library we each have synced down to our desktops via OneDrive. When either of us open the workbook, it opens Read-Only by default and forces us to click Edit Workbook to make changes. Of course, this locks the server copy. No co-authoring in sight. What do we need to do in order to get this functionality working using the desktop version of Excel?
May 07 2018 07:32 AM
Along a similar line... I'm looking for information - or better yet: if there are any detailed lab/test results - regarding the throughput and bandwidth usage of SharePoint Online/OneDrive file sync. What is the effect on WAN performance when a file is updated. For a setup of, say, 100+ workstations at an office location (on a LAN) that are sync'ing to SPO/OneDrive libraries, when SPO/OneDrive is implemented as a replacement for network shared drives: I'm particularly interested in what happens as one file is updated, what does the traffic look like when that file is then sync'd back down to all of the "subscribers". What is the difference (network performance data and user experience) when the file updated is pushed to clients. Then we would like to know what are the possible considerations for maximizing WAN and LAN performance.
May 08 2018 12:21 AM
May 08 2018 03:34 AM - edited May 08 2018 03:36 AM
Hi Hans,
I'm aware of Files OnDemand, but that is not what I'm asking about.
I'm asking specifically about the traffic for files that are stored on users' computers. They need to have some set of files sync'd locally, as they are in a location where internet connectivity is not that great. They will only use Files On Demand for files/folders they don't need to access regularly; but for files they already have sync'd locally, I want to know what is the WAN traffic/load when an updated file is then pushed to clients.
What's to worry about? user experience. There are some 200+ users (~300 devices) in a location with only ok Internet connectivity.
The benchmark user experience we would like to match is that of network shared drive access, which is: no lag time for access/update. Locally sync'd files have better experience, of course, but Files on Demand would have worse experience - due to waiting for file to download over WAN. Bad perception may end up with users rejecting OneDrive sync. We want to implement OneDrive sync, for purposes of business continuity, corporate document management (access by the rest of the organization, etc.).
I'm really curious to see if there are any engineering studies that have been shared and deeper description of the sync client behaviour. I have already been pointed to the Network utilization planning doc
May 08 2018 04:25 AM
One thing you'll be disappointed to learn @Daniel TSHIN is that unless something has changed since I posted this above several months ago, we've found that even when files are sync'd locally on your PC, Office will still open the file from OneDrive/SharePoint/Internet. So in the cases where you are in a poorly connected location, you wait a long time for it to open and close/save.
We've never been able to get an answer on why it behaves this way - we had hoped that it would be more like Outlook & cached mode.
May 09 2018 03:32 AM
Hi @Adrian Hyde, this is not we're experiencing.
Generally OneDrive NGSC behaves as expected for most of my users.
Today I experienced the opposite of what you're saying.
One group of users quarterly creates a document (for board of directors) where many people contribute to. Unfortunately this Word documents gets rather large very quickly, > 100MB due to a lot of images over 100 - 200 pages.
Word Online can no longer open this document size, and users rely heavily on Word 2016 with OneDrive NGSC to sync changes to file. With Automatic AutoSave you can quickly expect OneDrive NGSC to fail, as 5-10 users constantly upload and download over 100mb with that document.
I'm currently in a situation, where the CEO cannot open the Online Version of that file, and Word 2016 constantly opens some cached version that has a few merging errors. I've tried to delete everything offline from that document library, but Word still does not open the proper (most up to date) online version.
May 09 2018 01:43 PM
@Ivan Unger- my description wasn't clear...
What I mean is if you open the desktop version of Word (for example), and then open a file on your OneDrive - instead of using the version that is already cached on your PC - it will connect to the internet and download the file from OneDrive.
We can see that behavior in Fiddler traces.
We have many users in poorly connected locations, and would prefer to let the sync tool handle the upload/download behind the scenes as much as possible and let the users have the performance experience of working with the locally stored file.
May 10 2018 03:00 AM
Feb 26 2019 01:58 AM
Sorry for reopening an old discussion but I think this is something that we are experiencing also.
From the original post, I expected documents to be opened from the local synced copy but it appears that it opens them from the web which of course takes a lot longer on slower connections.
We can go to file explorer and then open from there (which is quick) and the "recent documents" in Word then show as c:-users-user-OneDrive. Again, opening that recent document is quick.
However, if we go to "recent documents" in Word and open from the connected OneDrive service, it seems much slower which I presume is because it takes it from the online storage rather than the synced local copy.
My expectation was that it would know that a copy was synced and so it would always take it from the local copy - is this not true?
Feb 26 2019 10:16 AM
Hello @Richard Rodgers -
Yes -we'd proven a while ago that this original article from @Stephen Rose was not correct...especially this part:
We've opened several premier cases who also confirmed the default behavior is that the client will always check the online file first...which really sucks when the network connection is horrible.
But at least there is some potential good news, if you have seen MC172851 - there is an upcoming change for PPT and Word.
We are looking forward to this working on all the Office apps.