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.

Microsoft Excel will now disable blocked file types from workbook links by default The files will either fail to refresh or show a #BLOCKED error Other safety updates ...