Thank you for your response. I've tried to replicate it again on my end, and got a different result, I've deleted the source file from my computer > access the file where the source file is inserted, and I didn't get the error messages.
Have you already performed the troubleshooting steps I've provided on my initial response?
I would suggest that you start Excel in safe mode, and see if there are add-ins that might be causing this.
If the issue also occurs in safe mode, try repairing Excel. If the issue still persists after repairing Excel, I highly recommend that youreinstall Office. There's a possibility that there are corrupted system files that's hindering Excel to work properly.
If yes, I'd like to know what is the build and version of your Windows and Office. To get this, follow the steps on the articles below:
Looking forward to your next revert.