What I've done is tell people to create documents from the "cloud" and edit them there within the Office365 ecosystem. Documentation needs where I work are fairly simple, with very few people needing much beyond the basic functionality. No one is doing amortization tables or complicated formulas. Word use is also fairly basic.
It seems that every week almost Microsoft changes the admin page for Office365 and adds or removes a feature or changes the way things look. Because of our basic Office needs, I'm seeing growing success with getting people to start and stay in the cloud. Prevents nonsense to a great degree. SharePoint to share between departments.
Oddly enough, I've had great success in "rescuing" Office files using LibreOffice running on Linux. Office files just add so much crufty proprietary stuff.
When I came by a few minutes later, all my laptop's docs had been moved into `C:/Users/<user>/OneDrive - <company>/Documents` and the Documents library adjusted to point there. And then all my non-Windows applications stopped working.
I mean, backup up is one thing. Relocating them is totally different. WTF Microsoft!
If you haven't tried it, you do not know what you are missing.
I've kept using Dropbox for all these years because they never confused people like this. There was a single app that gave you a folder that synced.
I hope that it will be useful and interesting to note that we have added 'rclone'[1] to our platform[2] which means that your rsync.net account is truly a swiss army knife for cloud storage organization.
This is very much like our 'borg' support - we actually have the binary executable installed on our end so you can run it properly. There is also a discounted signup for these two use-cases.[3][4]
[2] https://github.com/ncw/rclone/issues/3254
Google might drop any of their file syncing solutions, possibly even all three!
I think?
It is a game changer because it is simple. It is a virtual drive in the cloud that is fast and seamless and behaves as if it is local.
OneDrive cannot handle tons of files. It just doesn't work. It ends up freezing, you have no idea what's going on. Can't speak to macOS related stuff.
We finally were able to migrate off of this.. but we had a VERY file hefty folder structure. Instead of databases we chose to keep things in individual files for various reasons. Needless to say this didn't scale well, and there were about 750k files on the structure. Most of this was archival, but we simply didn't have the time or care enough to reduce the number of files.. we just wanted to be able to sync this to cloud data as is. Many files were super small, so never an absolute size thing just a LOT of files. And a chunk would keep changing throughout the day.
Dropbox was able to handle this for years- never an issue. Yeah it was fairly CPU intensive, but it worked very well.
I tried OneDrive on this.. what a nightmare. I tried owncloud, bittorrent sync, some others I can't even recall. Granted this has been about 3-4 years since I really tried some other ones with lots of files, but I was so annoyed every time I did.