Excel IMAGE function returns #CONNECT

Copper Contributor

Hello to all,

I have this image on OneDrive and shared it with no restrictions:

 

https://1drv.ms/u/s!AqaFWn73EcQBgaUCVXsp2ChBPw3IkA?e=FDn2eA 

 

When using it in this formula I get #CONNECT! in return.

 

=IMAGE("https://1drv.ms/u/s!AqaFWn73EcQBgaUCVXsp2ChBPw3IkA?e=FDn2eA")

 

 

I believe it has to do with some validation but googled around and found no answers.

Is this normal behaviour or is it possible to get the image on the spreadsheet like it happens for the examples given on the IMAGE function help?

Many thanks for any kind help,

Octavio

 

 

3 Replies
try
=IMAGE("https://s1.ax1x.com/2023/02/02/pSDfaMd.jpg")
if this works,I guess the resean is OneDrive links are not direct links for download images.
Hello and thank You.
Yes, using youk link, IMAGE function works and OneDrive links are not useful.
So this means that your image is located somewhere else...
May You let me know where?...

https://imgse.com/

or other image hosting