Forum Discussion
Solved
New Image Function
Is it possible to reference images stored in a OneDrive folder? I've tried copy the link from the OneDrive image and using which gets me #CONNECT! Any ideas Thanks
Any site which requires authentication, includes OneDrive, doesn't work with IMAGE().
I believe you'll need to include the extension of the image in the URL. IMAGE supports BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP.
Like this
=IMAGE("https://1drv.ms/u/s!AmbSxIyCxe5hktkARJfWxindUUDxyQ?e=OW2Gjb.jpg") - this didn't work. Have put the file type in the correct place?
I tried pasting this (Below) into a cell, and that took me to the correct image in my OneDrive
https://1drv.ms/u/s!AmbSxIyCxe5hktkARJfWxindUUDxyQ?e=OW2Gjb
I want to be able to have the image in the cell.
Thanks
=IMAGE("https://1drv.ms/u/s!AmbSxIyCxe5hktkARJfWxindUUDxyQ?e=OW2Gjb.jpg") - this didn't work. Have put the file type in the correct place?
I tried pasting this (Below) into a cell, and that took me to the correct image in my OneDrive
https://1drv.ms/u/s!AmbSxIyCxe5hktkARJfWxindUUDxyQ?e=OW2Gjb
I want to be able to have the image in the cell.
Thanks