Hi, I suggest you refer to this support article about block macro in Office from Internet: https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked You can try the suggestion and check if it will help you.
If the response is helpful, please click "Accept Answer" and upvote it. Note: Please follow the steps in [our documentation][10] to enable e-mail notifications if you want to receive the related email notification for this thread. [10]: https://learn.microsoft.com/en-us/answers/support/preferences