Don't know about Excel 2016, but my Excel 2010 default installation was Disable all macros without notification

maybe one of these will help

https://support.office.com/en-us/art...f-e8621e8fe373
https://www.youtube.com/watch?v=CyklPFw69_o
https://powerspreadsheets.com/how-to...-macros-excel/

Windows also has some setting somewhere that doesn't like running anything that came from the internet.
That was the line of thought for my previous post.

Beyond that, afraid I can't help you.