Forum Discussion
Stephen Rose
Microsoft
MicrosoftLearn How OneDrive Sync Works With Office 2016
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 ...
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?
