Image function isn't working on my iMac version of Excel.

The =Image function does not appear to work on my iMac version of Excel, but it does work on my iPhone version and MacBook Pro version... I'm running the 360 subscription which I believe excel needs to run this new feature (as of 2022) but for some reason my 2013 iMac doesn't want to play ball ? It just returns a <NAME> error. I assume a security feature isn't allowing external website access (which is where I will be accessing the image from) but I could be wrong. I have noticed as I type Image after the = it does not show as a valid function ? I've attached an image below to show. Can anyone help please?