I share a workbook with all of our Accounting staff (about 20 people) because we all need to make updates to it. For years we've kept the WB on a server, and everyone had access through Excel's shared workbook function. It's worked pretty well, but in the newer versions of Excel it keeps trying to steer us to Co Author. I've looked a little into this, and it seems the big difference is to host the WB on One Note or SharePoint. Neither of those options are very desirable for us. What are we missing out on by NOT Co Authoring?

BTW, related to this WB, it gets really slow as we go through the year because we have a ton of conditional formatting in each sheet (different colors for the same cells depending on where we are in the process). I'd like a way to "Lock" the CF colors once a line is completed (convert the CF colors to actual colors and delete that line from the CF range). Shared workbooks don't allow me to update CF unless I "Unshare" to do it then reshare. That's a pain.

I appreciate any help I can get on this.