Opening excel from teams with macro that are blocked

Question

Hi!

I'm opening an Excel file from a teams location. The excel contains macro's that are disabled when opening the excel. How to enable them? in the Trust center the macro's are enabled. But they are not...

Answer 1

Hi @Guy Henckaerts

Are these macros disabled if you open Excel files via Excel desktop app?

If so, I would suggest you try following steps to have a check.

• For files stored Files stored on SharePoint, including a site used by a Teams channel, please designate the location, such as https://{your-domain-name}.sharepoint.com , as a Trusted site.
• If conditions permit, it is recommended to download the Excel file to Trusted Locations that set in Office apps, and open it via Excel desktop app to check this issue.

If the issue still occurs, I suggest you check whether the file is removed Mark of the Web.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

---

Answer 2

Hi,

If the macros in your Excel file are disabled even though you have enabled macros in the Trust Center, it's possible that your file has been opened in a "Protected View."

So if that is the case, you'll have to disable the protected view.

Is there any specific error message you are facing?

Try referring to this link if that is the case and you may just find the fix.

https://answers.microsoft.com/en-us/msoffice/forum/all/macro-enabled-excel-file-not-working/dfa50c19-9637-46ca-912e-494846459d22

Best Regards.