There are many reasons you might want to protect an Excel worksheet with Read-only mode. Maybe you don't want someone to erase data from a workbook accidentally, or you want to make sure a file is not ...
If Excel keeps blocking files from being inserted, chances are the file is blocked by Trust Center, or maybe the workbook or locked. In some situations, we could be dealing with a corrupted file.