Excel file type (Excel 2007 and later Macro-Enabled Workbooks and Templates) will not save on MS 365 despite Trust Center settings

Question

Hi

I just got a new PC (Windows 10, Office 365) and have transferred some files over from my old PC (Windows 10, Office 2016). One of the Excel files has an "xmlm" file extension as it has some embedded VB code. 

I keep getting this when trying to save the file:

However, when I go to Trust Center, the appropriate check box is checked:

What else do I need to do enable saving this file?

Answer 1

Hi there,

Thank you for reaching out to us. I am an Independent Advisor and Microsoft user just like you.

For this issue, you should leave the options unchecked instead of being checked. As stated in the link below, "Clear the option means allow user to open or save the file. Check the option means block the file.". Please refer to the link for more information.

Please feel free to ask me if you still could not do it.

https://docs.microsoft.com/en-us/office/trouble...

I hope this would help you resolve your issue.

Regards,

Thuy

Answer 2

LOL thanks I feel stupid now.

Answer 3

I am glad to know that you would sort it out.

Thank you and happy coding!