Customers are unable to form ranges that consist of locked cells with a protected worksheet, irrespective of this location. If just one particular person does this, then All people else can get the "locked" mistake—regardless of whether everyone else is utilizing a version of Excel that does assistance co-authoring. https://g.co/kgs/CGS5nc7