Customers can not form ranges that incorporate locked cells on a protected worksheet, no matter this setting. If you're still receiving the "locked" error, see Excel file is locked for modifying For additional answers to this issue. What you need to know: The condition released a refreshed Edition of https://g.co/kgs/CGS5nc7