Forum Discussion
I can't open a Macro enable excel and word file
Roxanne26
Have you recently applied the new o365 user security baselines? One of the changes from the 2016 baselines to this one, was the addition of this policy:
User Config > Admin Templates > Excel 2016 > Excel Options > Security
Force File extension to match file type
This is enabled by default through the baseline, this was a gotcha for us.
The file may also be incorrectly labeled as "from the internet", and even if you have macros enabled, this GPO will override that:
User Config > Admin Templates > Excel 2016 > Excel Options > Security > Trust Center >
Block Macros from running in Office files from the Internet
Last but not least, there's the AMSI GPO, where office will leverage defender to scan macros and block them.
"This behavior can be controlled by Group Policy. In the Group Policy Editor go to the Microsoft Office 2016 template and under Security Settings you should find Scan VBA macros at runtime. "
https://support.office.com/en-us/article/malicious-macros-were-found-9e461c61-69d1-4ea9-a386-9ad0deaccfdd
Let me know if any of those steps helped!