What version of Office are you using?
Please check if workaround in this article "Cannot use object linking and embedding" error in Excel 2016 for Mac is helpful to you.
Any updates, please let me know.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.