Hi,
some time ago I migrated most of my documents to OneDrive because of cloud and backup and stuff, but I just can't get the right configuration.
I use win 10 + Office 2016 x64 + One Drive personal, but hey this OneDrive sometimes drives me nuts. Man why can't they make it simple and working just like Dropbox is.
The setting that I believe is related to my problems is under oneDrive --> office tab --> Use Office 2016 to sync Office files that I open.
ON
this seems a good solution, all opened files are automatically synced and saved to cloud, I get no duplicate copies and I can see version history right in office documents which is great. I however often work with documents that are linked to other documents/files or needs to access them via VBA. And when I open pinned or recent document directly from excel or from start menu->excel shortcut, it is opened directly from oneDrive, instead of regular folder. And that makes thisworkbook.path to be something like https://d.docs.live.net/blablablanumbers/folder/ instead of c:\users\user\onedrive\folder and that means zillion errors are thrown and there is no access to files the document works with. I did not find a solution to this. If I open file from my local folder (in onedrive folder), close excel, open excel, open recent file, its still the web version.
OFF
I believe this is more dropbox-like approach, files are uploaded separately with office upload center after they are saved. The issue with files being directly opened from onedrive is gone, however time to time excel makes duplicate copies of files, saving takes longer and it just does not work very well.
anyone exeriencing this problem maybe have a solution? I choose oneDrive over dropbox because of capacity I have there.
some time ago I migrated most of my documents to OneDrive because of cloud and backup and stuff, but I just can't get the right configuration.
I use win 10 + Office 2016 x64 + One Drive personal, but hey this OneDrive sometimes drives me nuts. Man why can't they make it simple and working just like Dropbox is.
The setting that I believe is related to my problems is under oneDrive --> office tab --> Use Office 2016 to sync Office files that I open.
ON
this seems a good solution, all opened files are automatically synced and saved to cloud, I get no duplicate copies and I can see version history right in office documents which is great. I however often work with documents that are linked to other documents/files or needs to access them via VBA. And when I open pinned or recent document directly from excel or from start menu->excel shortcut, it is opened directly from oneDrive, instead of regular folder. And that makes thisworkbook.path to be something like https://d.docs.live.net/blablablanumbers/folder/ instead of c:\users\user\onedrive\folder and that means zillion errors are thrown and there is no access to files the document works with. I did not find a solution to this. If I open file from my local folder (in onedrive folder), close excel, open excel, open recent file, its still the web version.
OFF
I believe this is more dropbox-like approach, files are uploaded separately with office upload center after they are saved. The issue with files being directly opened from onedrive is gone, however time to time excel makes duplicate copies of files, saving takes longer and it just does not work very well.
anyone exeriencing this problem maybe have a solution? I choose oneDrive over dropbox because of capacity I have there.
