If Delete rows is guarded and Insert rows is not also protected, a person can insert rows that they can not delete. If you're still obtaining the "locked" error, see Excel file is locked for editing for more options to this problem. Do a number of of the subsequent: https://g.co/kgs/CGS5nc7