Forum Discussion

andrey-andrey's avatar
andrey-andrey
Copper Contributor
Jan 05, 2024

IMAGE function is #BLOCKED! on macOS

I'm using IMAGE function to get an image from URL. Once it's loaded, it's also cached, but the result of my endpoint may change over time. So, to prevent caching, I've added a little hack with NOW function.

Here I'm using https://random.imagecdn.app as an example:

 

=IMAGE("https://random.imagecdn.app/500/150?" & NOW())

 

On Windows every time I open my file, image is updated (which is expected).

But on Mac the cell, containing this formula, is #BLOCKED!:

Clicking "Enable Content" doesn't help:

Error checking popup says "Check security settings", but there's nothing to check really:

Every checkbox at "Preferences -> Privacy -> Manage Connected Experiences" is enabled.
Here's Excel version I'm using:

How can I achieve the same result on Mac as on Windows?

Excel on Mac
Formulas and Functions
  • sparkyo's avatar
    sparkyo
    Copper Contributor
    Jun 06, 2024
    Any solutions? I am facing exactly the same problem
  • DoeMurf's avatar
    DoeMurf
    Copper Contributor
    Jul 03, 2024
    SAME! Any New Ideas? I have my images on Onedrive and have watched how it works on Windows Excel ....but no "Trust Center" on a mac?
    • DoeMurf's avatar
      DoeMurf
      Copper Contributor
      Aug 14, 2024

      CharlieZ138 

      I found a work around that is working for me

      upload images and excel file on onedrive

      Set all images and excel files share permissions to everyone

      open excel file in OneDrive live

      on OneDrive file manager choose image & hit three dots- click on embed & copy code

      then create a column for Image Path and paste the embed code into a column

      In another column use IMAGE formula to point to the column w/ embed code

       

Resources