Forum Discussion
oteixeira62
Feb 06, 2023Copper Contributor
Excel IMAGE function returns #CONNECT
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
- peiyezhuBronze Contributortry
=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.- oteixeira62Copper ContributorHello 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?...- peiyezhuBronze Contributor