I've been building out an Excel operating model for a company I work with and we're at a point where we want to share this model with their broader team. We're aiming for a few things...
1) Some worksheets are relevant to some users, but not to others. Moreover, some worksheets contain sensitive data that should only be viewable to certain users. So we really need to be able to control view and edit settings at the worksheet and user level.
2) We'd like multiple users to be able to work on the workbook at the same time.
What's the best way to accomplish this? Also, is OneDrive or SharePoint the optimal solution here, or are there other approaches that are just as good or better? (In case it's relevant, I use Excel via Office 365.)