Hello,
I was wondering if anyone would be able to provide some insight on why it seems the prompt to enable macro's on Excel behaves very inconsistently. Our CRM system gives files the 'Mark of the Web' so following the recent changes (https://techcommunity.microsoft.com/t5/microsoft-365-blog/helping-users-stay-safe-blocking-internet-macros-by-default-in/ba-p/3071805)) when we open one it will NOT give the option to enable Macro's and only prompt to disable them with a learn more bar displayed at the top of the screen. Looking at the post this is now the correct behaviour.
However, I've found whenever I have a locally saved Excel file already open with Macro's enabled. Opening a spreadsheet from the CRM will give you the option to enable the macro's, I'm unsure why having another copy of Excel open would affect the behaviour of this.
Version: Excel Version 2211 Build 15831.20208 Click-to-Run / Build 16.0.15831.20098 32bit