=Image returns a #connect error

[wpryan023]

Hi All, I'm experimenting with the new =Image function, and somehow I can't get it to work. I copied a file to my sharepoint site, set the permissions to "anyone can view". I copied the URL and pasted it into the workbook. If I click on the hyperlink, the file opens. However, if I insert the function =IMAGE(A1,,2) I get a #connect error. 

...any ideas?

...

[#2]

@wpryan023 

You must use a link to the internet. A link to a cell does not work.

Syntax

=IMAGE(source, [alt_text], [sizing], [height], [width])

source The URL path, using an "https" protocol, of the image file. Required. Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP.

=IMAGE("https://upload.wikimedia.org/wikipedia/commons/thumb/0/04/Eintracht_Frankfurt_Logo.svg/550px-Eintracht_Frankfurt_Logo.svg.png")

[#3]

The IMAGE function may point to a cell containing a URL. I have a workbook with several hundred links in another sheet and IMAGE works with them with no issue. I show/hide images with a drop down.

The #CONNECT error may be due to an unsupported file type or external content being blocked.
Image supports: BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP..

Details on external content:
https://support.microsoft.com/en-us/office/block-or-unblock-external-content-in-office-documents-102...

[#4]

Thanks for your reply. I tried with a picture from my company website and it's working. The pictures I want to link are on my SharePoint site. If I click directly on the link, then the picture opens normally in my browser, I just can't get it to open in the file...

[#5]

@wpryan023  I'm having same issue, did you get this resolved? Thanks

[#6]

@CQ1953 , no the issue is not resolved. I think it's a limitation with the Excel function. I really would like to get it working!

[#7]

not working for me as well, looking forward for the issue to be resolved.