Customers can't kind ranges that have locked cells over a protected worksheet, no matter this setting. If another person is employing OneDrive to sync files, they need to have to make sure it is not paused. And they need to have the Use Office 2016 to sync data files... https://g.co/kgs/CGS5nc7