If you can't edit macro-enabled Excel file because Microsoft has blocked macros from running because the source of file is ...

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.