OneDrive is an abomination. We use it at work and I have to manage it for everyone on top of my other duties (medium non-profit). It's not the panacea everyone thought it would be. I inherited it upon coming here. I've tried to see this as more or less a devops experiment. I try to control as much as I can with PowerShell, but some things don't lend themselves well to that method. Oddly enough, the lion's share of all end users are on Macs that are on a Windows domain. It proved interesting to get everything working.

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.